Forum Discussion
Sorting Table for two rows for Top 5 for each.
This is sort of complicated and I will need help in steps.
I use the measure below in Filter for table and use " is less than or equal to 5"
Top 5 Report Locations and Cause by Freq then Sum = CALCULATE([Count of Total Gross Incurred No Row],KEEPFILTERS(TOPN(5,ALL(LossRunToExcel[Reporting Location City]),[Count of Total Gross Incurred No Row],DESC,[Sum of Total Gross Incurred],DESC)))
I get the following
How can I exclude if cause count is 0 Fort Meyers has 4 causes with count of one and 11 with count of 0 or exclude if 0?
3 Replies
Which measure or fields keeps out 0 for any City with Quantity of Zero for Name?
I am still playing around with the sample download. How dos this break ties if Value chosen is 2 and as A shows there are 3 because V an X are both 24. Can a count and then a sum be introduced somewhere to break the tie?
