11-12-2016 06:43 AM - last edited 01-09-2017 11:14 AM
This is one of my first reports in order to control maintenance costs. This is a very simple version an it was my first full report made about 1 year ago problably a lot of mistakes this as already evolved to other features.
You have done an excellent work here! I have a question. How do you create the "Top N" filter in the 3rd page? I'm trying to do something like that but I don't know how to do it.
Thanks in advance!
Thank you for your compliment.
The Top N is made using a table for the ranking numbers and 3 measures. Currently using the What if Parameter you can create a parameter from 1 to 100 and make it incremental.
Then create 3 measures:
Rank = RANKX ( ALLSELECTED ( Table[Column] ); CALCULATE ( SUM ( Table[ValuesColumn] ) ) ) TOP_N = if ([Rank]<= MAX('TopN'[TopN]);1,0;BLANK()) Top N Total = CALCULATE ( SUM ( Table[ValuesColumn] ); FILTER ( ALL ( Table[Column] ); [Rank] <= MAX ( 'TopN'[TopN] ) ) )
Then Top N Total gives you the total based on the filter by the slicer of the TOP N and the TOP_N measure should be added as a filter (visual or page) and set to Not Blank this will filter out all the results you don't have when choosing the N filter.
Hey @MFelix I am amazed by how ease and great to read is this report. Did you make it available in any link? Is there a way to donwload it the way I could play with it?
Thank you for sharing.