Forum Discussion
Solved
Top N - Simply do not understand it.
Hi I can't for the life of me work out what simple method to get a Top 5. I have a column that collects Hazard types in a sharepoint list. I would like to use a Multi-Row card to display the ...
You are getting 7 for Top 5 because of the duplicate values. 2 is the fifth result and there are 3 rows with that value
PaulDBrown
Community Champion
Community ChampionThe measure is needed to filter the TopN in the filter pane:
In this example, I'm using this measure
Hazard Count =
COUNT('Table (2)'[Hazard])
I think I understand. Followed it but it gives me 7 results.
Measure -
HazardCount = COUNT(HazardDatabase[Hazard Type])