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.

     

     

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

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

        Hi amitchandak ,

         

        Thanks for the reply Amit but its still not working. 😞