Text box first two Countries name

[Anonymous]

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.

Thanks,

Y_DK

[TomMartens]

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

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Try this measure in a Card visual

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

Regards

Phil