Maintenance report 11-12-2016 06:43 AM - last edited 01-09-2017 11:14 AM

[MFelix]

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

eyJrIjoiNjcwMWI2OTctNWZjZi00NTUyLTkzODEtZmQ4YTE4ZDhhNWI5IiwidCI6IjMwNDljMmY0LWNlMWUtNDlkOS1iZTYwLTNiNmFiNDAyODQ0YiIsImMiOjh9

[Anonymous]

Good afternoon Miguel, I love the maintenace report. I have something simliar which is Prevent Maintenace and have issues even Beginning with the Data model any suggestion or can you send me a copy so I can see how you were able to arrange you data table.

lydriarivera@gmail.com.

thank you

[mahesh009]

Please share Power BI file if possible. Thanks

[Renata]

Hi @MFelix! I really love your dash! Is it possible share with me? Layout is so  clean!

My email is renatagabardo@gmail.com

Tks and congrats!!

[anizioneto_ca]

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

[angova]

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!

[MFelix]

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

[angova]

Hi @MFelix,

That works! Thank you so much.