Forum Discussion

rebecka's avatar
rebecka
Frequent Visitor
6 years ago

Top N Table

Hi, Is there a way to create a table in Power Query to get Top N organizations dynamically? I have some visuals and I want them all to present data from my Top N organizations, but Top N organizati...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi rebecka 

Besides measures created in my previous reply,

Create measures below

count = COUNT(Sheet9[key])

condition = IF([ShouldOrgBeIncluded]=1,[count])

final output = SUMX(FILTER(ALLSELECTED(Sheet9),Sheet9[condition]<>BLANK()&&Sheet9[result]=MAX(Sheet9[result])),[condition])

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  • rebecka's avatar
    rebecka
    Frequent Visitor
    6 years ago

    Hi v-juanli-msft !

    It works fine for this small dataset, but when I tried to apply it to my original report with a much larger data set I get out o memory exception.

    And also I would like to add a date dimension to this and I'm not sure if it's possible to implement this in a line chart with date on the x-axis (only showing lines of the highest ranked).

    Best Regards, Rebecka