Maintenance report
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 e...
Hi angova,
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.
Regards,
MFelix
