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.

 

 

Thanks,

Y_DK

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

2 Replies

  • 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

  • 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