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

TomMartens's avatar
TomMartens
Super User
5 years ago

Hey Anonymous ,

 

I created this measure

Top 2 Colors = 
CONCATENATEX(
    TOPN(
        2
        , ADDCOLUMNS(
            SUMMARIZE(
                'FactOnlineSales'
                , 'DimProduct'[ColorName]
            )
            , "amount" , [Total OnlineSales Quantity]
        )
        , [Total OnlineSales Quantity]
        , DESC
    )
    , CONCATENATE( CONCATENATE( [ColorName], ": " ) , [amount] )
    , ", "
    , [amount]
    , DESC
)

The essential part is the nesting of the 2 functions
CONCATENATEX( TOPN( 2, ...
Then I used this measure inside the visual itself

, but of course you can use it in every visual that supports dynamic a title/text

 

Hopefully, this provides what you are looking for. If not, please consider to create a pbix file that contains sample data but still reflects your data model. Upload the file to onedrive or dropbox and share the link. If you use EXCEL to create the sample data share the xlsx as well.

 

Regards,

Tom