locked
Compare calculated column with measure RRS feed

  • Question

  • Hello everyone,

       My problem is : I have a calculated column in dimension that return me 1,2,3 or 4 and measure that return me same value and i want to create a measure that compare the value, if the value are equal then my measure retrun "equal" if the calculated column is superior the measure return me "superiro"...etc. I got when i try to show this in Power BI this error :

    MdxScript(Model) (1, 56) Calculation error in measure : A table of multiple values was supplied where a single value was expected. and when i try to show this with attribut i got the error of not enough memory.

    Someone can help me please.

    Regards,

    Amar


    Reponse

    Wednesday, March 6, 2019 12:54 PM

Answers

  • Hello,

       i Found the solution, create a measure with the calculated column using the FIRSTNONBLANK and after that we can compare the two measure ;) .

    Regards,

    Amar


    Reponse

    • Marked as answer by Adghar Thursday, March 7, 2019 9:17 AM
    Thursday, March 7, 2019 9:17 AM