Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Measure not working for calculated column

I have written a measure to format a calculated column but am getting an error message.   The measure is "Variance1 = IF('Forecast Expense'[Variance]=-0, 'Forecast Expense'[Variance]*-1, 'Forecast ...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    You can change the measure using MAX function to get values for every rows like DAX below.

     

    Variance1 = IF(MAX('Forecast Expense'[Variance])=-0, MAX('Forecast Expense'[Variance])*-1, MAX('Forecast Expense'[Variance]))

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

You can change the measure using MAX function to get values for every rows like DAX below.

 

Variance1 = IF(MAX('Forecast Expense'[Variance])=-0, MAX('Forecast Expense'[Variance])*-1, MAX('Forecast Expense'[Variance]))

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.