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.

     

     

     

     

     

     

     

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

CEllis First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8