Forum Discussion
Top N Measure and Need 3rd Variable
I use the following measure allot in my report to calculate Top N for visuals.
Top 25 Cause Group Freq then Sum = CALCULATE([Count of Total Gross Incurred],KEEPFILTERS(TOPN(25,ALL(InjuryCause[Cause Grouping]),[Count of Total Gross Incurred], DESC,[Sum of Total Gross Incurred],DESC)))
There are times when after using Count of Total Gross Incurred then Sum of Total Gross Incurred to break ties I still end with more than the N I selected.
What 3rd variable could I use and how would I add it to the measure to break remaining ties?
1 Reply
bdehning The only way I know to absolutely break ties in DAX is to use The Mythical DAX Index - Microsoft Power BI Community
