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.

     

     

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.