Forum Discussion

CEllis's avatar
CEllis
Resolver I
2 years ago
Solved

Measure not counting

Afternoon,   I have 2 measures that calculate if one is above or below the other. I can get this far but for some reason it wont total the 'Movement (Up)' or Movement(Down) measures and the 'M...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi CEllis ,

    I create a table as you mentioned.

    Maybe I think you can use this calculated column, here is the DAX code.

    Column = IF('Table'[Current]>'Table'[Previous],"Current","Previous")

     

     

     

    Best Regards

    Yilong Zhou

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

     

     

     

     

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi CEllis ,

I create a table as you mentioned.

Maybe I think you can use this calculated column, here is the DAX code.

Column = IF('Table'[Current]>'Table'[Previous],"Current","Previous")

 

 

 

Best Regards

Yilong Zhou

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