Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |