Forum Discussion
bdehning
Post Prodigy
Post ProdigyNeed help with Measure for Matrix Table and Top 5
I really need help in writing a measure. I have attched sample PBI Table and screen shot of current table. I use a Filter for the Reporting Location City and a Measure that shows the Top 5 Reportin...
bdehningPost Prodigy
Post ProdigyYes Thank you so much.
How would you tweak the two measures If I have a page where Sum is looked at first and tie breaker would be count?
Top 5 by Frequency and Incurred measure would be easy to swap out Sum of Total for Count of Total but what abour Ref?
Ref =
COUNT(LossRunToExcel[Reporting Location City]) * 1000000000000 + [Sum of Total Gross Incurred]
PaulDBrown
Community Champion
Community ChampionI would go for:
Ref =
[Sum of Total Gross Incurred] * 1000000000000 + COUNT(LossRunToExcel[Reporting Location City])
- bdehning
Thanks again for the work.