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] = COUNT('Claims Fact'[Tariff Code ID]) 

 

Rank Tariff by Selected View = IF(
      HASONEVALUE('Tariff Dimension'[Tariff Code]);
      RANKX(
            ALLSELECTED('Tariff Dimension'[Tariff Code]);
            [Selected Tariff View]
      )
)

 

Here is the result:

 

I now add the associated description to the Table visual. But when I do, I loose the rank. Here is what happens:

 

What am I doing wrong?

 

Thanks..

 

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]
    )
)

4 Replies

  • 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

  • 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.