Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm needing help with two seemingly easy DAX calculations, but I'm not able to get anything working. I'm trying to create a measure called [AMOUNT2] that takes the sum of [AMOUNT] (this is a column in my table), grouped by [ID], [SOME_ID], and [ANOTHER ID]. Once [AMOUNT2] as been caculated, I wanted to create a measure called [MAX_OF_AMOUNT2] that takes the max of [AMOUNT2] and is grouped by [ID].
Any ideas or direction would be most helpful! I've provided a visual example of the data table below for reference.
Solved! Go to Solution.
Hi @Anonymous
Create two measures
Measure = CALCULATE(SUM(Table1[amount]),ALLEXCEPT(Table1,Table1[id],Table1[some_id],Table1[another_id])) Measure 2 = MAXX(ALLEXCEPT(Table1,Table1[id]),[Measure])
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Create two measures
Measure = CALCULATE(SUM(Table1[amount]),ALLEXCEPT(Table1,Table1[id],Table1[some_id],Table1[another_id])) Measure 2 = MAXX(ALLEXCEPT(Table1,Table1[id]),[Measure])
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Maggie, would be nice if you can put an explanation of what the two measures is doing so that a newbie like myself can understand what is going on. Especially the function AllExcept, I still find it difficult to undestand 🙂
Thank you
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |