Forum Discussion

raj777karthik's avatar
raj777karthik
Microsoft Employee
3 years ago
Solved

TOPN dax function as variable

Need to show top 5 services in table visual.   Service Name Count Total Count Apple 43 346 Samsumg 67 346 mi 80 346 oppo 84 346 google 72 346   Measure written we...
Table Column
raj777karthik's avatar
raj777karthik
Microsoft Employee
3 years ago

In Rank measure,im getting values 1 and 2.

 

 

v-yadongf-msft's avatar
v-yadongf-msft
Community Support
3 years ago

Hi raj777karthik ,

 

Can you tell me how the RANK measure did you write?

 

Best regards,

Yadong Fang

  • raj777karthik's avatar
    raj777karthik
    Microsoft Employee
    3 years ago

    Same as you have mentioned.Created measure for this.

    Rank = RANKX(ALLSELECTED('Stack Tags'),[Count],,DESC,Dense)

    • v-yadongf-msft's avatar
      v-yadongf-msft
      Community Support
      3 years ago

      Hi raj777karthik ,

       

      OK, I know the reason of the problem.

       

      Please try following DAX:

      Rank = IF(HASONEVALUE('Stack Tags'[Service]),
    RANKX(ALL('Stack Tags'[Service]),[Count],,DESC,Dense)
)

      Best regards,

      Yadong Fang

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

       

      • raj777karthik's avatar
        raj777karthik
        Microsoft Employee
        3 years ago

        Hi,

        Thanks Rank is working fine as expected,but the total count measure is returning all the values.

        Total count = CALCULATE([Count],FILTER(ALL('Stack Tags'),'Stack Tags'[Rank]<=5))