Ranking

[unnijoy]

Hi Team,

I have to create a Table visual that will show Rank based on csat. Csat am calculating by using a measure. I need to create a RankX measure that will dynamicaly show the Rank. One table shouls show the Rank based on country,Other based on Manager and the other based on City. Currently am using the below measure

RANKX(ALLSELECTED('CSAT Dump'[Country]) ,[6_Curr_Csat%],,DESC,Dense)

The issue with the above one is that for each table i have to create it seperatly. One for country,other for Manager like that. how can i create a dax which will work dynamically.

[lbendlin]

Evaluate the use of ISFILTERED or ISINSCOPE.  Also consider using Calculation Groups.

[unnijoy]

Its not working.

[v-shex-msft]

Hi @unnijoy,

Can you please share a pbix or some dummy data with raw data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[unnijoy]

Hi @v-shex-msft ,

Below is the raw data format.

Raw Data

Csat formula is Count of 1&2/ Total count of csat

Eg: Manger Leo =3/4=75%

Now what we need is that a dynamic rank formula.

So when we can us it in table for any visual.

Currently am using the below formula 

RANKX(ALLSELECTED('CSAT Dump'[Manager]) ,[Csat%],,DESC,Dense)

but this is not dynamic. If i need to show county wise csat% then i have to change 'CSAT Dump'[Manager] to 'CSAT Dump'[Country].

How can i make this Dynamic.

[v-shex-msft]

HI @unnijoy,

>>Csat formula is Count of 1&2/ Total count of csat

I'm not so clear about this, can you please share the csat expressions?

Regards,

Xiaoxin Sheng

[unnijoy]

Hi @v-shex-msft ,

The Csat will range from 1 -4. We will consider 1 and 2 as Csat. Rest we won;t consider. So if the csat is 1 or 2 will consider rest are like Dsat. csat %= count of (1or 2)/ Total count(1-4)

[v-shex-msft]

Hi @unnijoy,

Perhaps you can try to add a variable with summarize function to aggregate your records based on category and ranking on the variable table, then you can use the current category value to lookup correspond ranking values.

All the secrets of SUMMARIZE - SQLBI

Using the SELECTEDVALUE function in DAX - SQLBI

DAX - The Many Faces of VALUES() | P3 Adaptive

Regards,

Xiaoxin Sheng