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
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    Hi raj777karthik ,

     

    Please replace measure with new column and try again. 

     

    Best regards

    Yadong Fang

    TOPN dax function as variable2.pbix20 KB
v-yadongf-msft's avatar
v-yadongf-msft
Community Support
3 years ago

Hi raj777karthik ,

 

Can you tell me how the [Count] measure did you write?

 

It's better to share with me a screenshot of the original data (hide sensitive information).

 

Best regards

Yadong Fang

raj777karthik's avatar
raj777karthik
Microsoft Employee
3 years ago

Measure written:

Count = COUNT('Stack Tags'[Service])
Rank = IF(HASONEVALUE('Stack Tags'[Service]),
    RANKX(ALL('Stack Tags'[Service]),[Count],,DESC,Dense)
)
Total count = CALCULATE([Count],FILTER(ALL('Stack Tags'),'Stack Tags'[Rank]<=5))
 

 

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

    Hi raj777karthik ,

     

    Please replace measure with new column and try again. 

     

    Best regards

    Yadong Fang

    TOPN dax function as variable2.pbix20 KB
  • raj777karthik's avatar
    raj777karthik
    Microsoft Employee
    3 years ago

    Thanks Yadong.Its working fine.