Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Text box first two Countries name

Hi Team,   I have country name and volume table, In that table i need Funnal chart for Top N country list, how ever I want to display first two country name list in Text box ,based on DAX.   ...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Anonymous 

    Try this measure in a Card visual

     

    Top2 = CONCATENATEX(TOPN(2,'Table','Table'[Volume],DESC),'Table'[Country],", ")

     

    Regards

    Phil

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi Anonymous 

Try this measure in a Card visual

 

Top2 = CONCATENATEX(TOPN(2,'Table','Table'[Volume],DESC),'Table'[Country],", ")

 

Regards

Phil