topic Re: Top N issue in DAX Commands and Tips

Top N issue

pmadam — Wed, 31 Aug 2022 23:38:16 GMT

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

Re: Top N issue

amitchandak — Thu, 01 Sep 2022 01:26:43 GMT

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]) )

Re: Top N issue

pmadam — Thu, 01 Sep 2022 01:42:31 GMT

No change. Im i doing something wrong.

Re: Top N issue

amitchandak — Thu, 01 Sep 2022 02:57:03 GMT

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

Re: Top N issue

pmadam — Thu, 01 Sep 2022 03:48:18 GMT

Hi amitchandak ,

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

Re: Top N issue

v-xiaotang — Thu, 08 Sep 2022 09:51:47 GMT

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.