Maintenance report

Super User
3838 Views
Super User
Posts: 1,944
Registered: ‎09-19-2016

Maintenance report

[ Edited ]

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.

 

MFelix

 

 



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Frequent Visitor
Posts: 6
Registered: ‎12-04-2017

Re: Maintenance report

Hi @MFelix

 

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!

Super User
Posts: 1,944
Registered: ‎09-19-2016

Re: Maintenance report

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Frequent Visitor
Posts: 6
Registered: ‎12-04-2017

Re: Maintenance report

Hi @MFelix,

 

That works! Thank you so much.

New Member
Posts: 1
Registered: ‎10-11-2018

Re: Maintenance report

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.

Cordially,

anizioneto_ca