Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Ranking within Table Visual not working

Hi,   I have a Table visual that displays a code and its associated description. I am able to rank the code according to its frequency using the following DAX expression:   [Selected Tariff View]...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi Anonymous

     

    Add Tarriff Description as a parameter

     

    Rank Tariff by Selected View =
IF (
    HASONEVALUE ( 'Tariff Dimension'[Tariff Code] ),
    RANKX (
        ALL ( 'Tariff Dimension'[Tariff Code], 'Tariff Dimension'[Tariff Description] ),
        [Selected Tariff View]
    )
)
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Also, you may want to explore the LOOKUPVALUE() function to bring over the description field into your Table.