Forum Discussion
Solved
DAX Formula Help Needed - Summing Measures
Hello fellow Power BI Community Members, I am working on a report that requires the use of multiple measures. The problem is that I am stuck part way through the process, as using some of the mea...
This works like a charm! I didn't know that was a possibility, but it certainly met my needs. Thank you!
Just in case it helps someone else who is running into the same problem, here is the formula I used to get what I needed:
Top 3 Month Summary = SUMX(SUMMARIZE('Pivoted Data','Pivoted Data'[Month]),[Top 3])
Top 3 = VALUE(IF([Rank] <= 3, CALCULATE(SUM('Pivoted Data'[Value])), 0))
The Top 3 measure allowed me to assign a 0 to anything that is not in the Top 3, and then I was able to use the SUMX(SUMMARIZE)) measure to total that up for use in other calculations. It works similarly for the bottom 3 values I needed.