MFelix's avatar
MFelix
Super User
9 years ago

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 evolved to other features.

 

MFelix

 

 

Business

7 Replies

  • anizioneto_ca's avatar
    anizioneto_ca
    New Member
    7 years ago

    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's avatar
    angova
    Frequent Visitor
    8 years ago

    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's avatar
      MFelix
      Super User
      8 years ago

      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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.

    [email protected].

    thank you