Forum Discussion
Compare aggregated values and select max
I need help to summarize the data for a category per user and count the results filtered by max value for each user For ex: In the below image, user - "SL-08" has an entry for category - H and 2 ...
Greg_Deckler
Community Champion
Community ChampionAnonymous - Can you post sample data as text and expected output? So much easier to troubleshoot if I can recreate the problem locally.
Greg, V-lianl-msft,
Apologies, i created a duplicate post.
Greg_Deckler - please take a look at this thread. I've tried to explain the scenario and added sample data, with expected result
https://community.powerbi.com/t5/Desktop/Compare-counts-with-in-group-rank-and-count-the-top-values/m-p/1291186/highlight/true