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]
    )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
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]
    )
)
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Zubair_Muhammad,

 

I see you have used 'ALL' which gives you the option of adding another parameter instead of 'ALLSELECTED', which is what I am using but doesnt give the option of additional parameters.

 

I am using 'ALLSELECTED' as I want to maintain the filter context of any filters already selected. Is there any way to do what you have suggested but with keeping the Filter context of any filters already selected?

 

Thanks

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    HI Anonymous

     

    Interesting...

     

    Could you show how it impacts your results?.....The incorrect result and result you expect