Forum Discussion

pmadam's avatar
pmadam
Icon for Helper II rankHelper II
4 years ago
Solved

Top N issue

I am trying to get top 5  part number by ATS_Score since Part number is whole number,I am not able to do do top 5. later tries buy domain, still doesnt work. 

Please help

 

   

 

 

  • pmadam's avatar
    pmadam
    4 years ago

    No change. Im i doing something wrong.

     

     

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    pmadam , You need to try measure like

     

    2 column top N = CALCULATE([Measure], TOPN(10, SUMMARIZE(ALLSELECTED('Table'), 'Table'[Domain], 'Table'[Part Number]), [Measure],DESC),VALUES('Table'[Domain]), VALUES('Table'[Part Number]) )

    • pmadam's avatar
      pmadam
      Icon for Helper II rankHelper II
      4 years ago

      No change. Im i doing something wrong.

       

       

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        4 years ago

        pmadam , The measure you are using for TOPN seems to me using +0 or handing blank, remove any such code and use this measure as a visual level filter and check for non blank

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi pmadam 

    Thanks for reaching out to us.

    >>I am trying to get top 5  part number by ATS_Score

    you can try this measure, then put it into visual-level filter,

    RANK = RANKX( SUMMARIZE(ALL('Table'),'Table'[Domain],'Table'[Part Number]) , CALCULATE( SUM('Table'[ATS_SCORE]),ALLEXCEPT('Table','Table'[Domain],'Table'[Part Number])),,DESC,Dense)

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.