Ranking

Question

Hi Team,&nbsp;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 measureRANKX(ALLSELECTED('CSAT Dump'[Country]) ,[6_Curr_Csat%],,DESC,Dense)&nbsp;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 · Answer

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

unnijoy · Answer

Its not working.

anonymous · Answer

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&nbsp;&nbsp;
Regards,
Xiaoxin Sheng

unnijoy · Answer

Hi&nbsp;Anonymous&nbsp;,Below is the raw data format.Raw DataCsat formula is Count of 1&amp;2/ Total count of csatEg: Manger Leo =3/4=75%Now what we need is that a dynamic rank formula.&nbsp;So when we can us it in table for any visual.Currently am using the below formula&nbsp;RANKX(ALLSELECTED('CSAT Dump'[Manager]) ,[Csat%],,DESC,Dense)&nbsp;but this is not dynamic. If i need to show county wise csat% then i have to change&nbsp;'CSAT Dump'[Manager] to&nbsp;'CSAT Dump'[Country].&nbsp;How can i make this Dynamic.

anonymous · Answer

HI&nbsp;unnijoy,
&gt;&gt;Csat formula is Count of 1&amp;2/ Total count of csat
I'm not so clear about this, can you please share the csat expressions?
Regards,
Xiaoxin Sheng

Forum Discussion

Ranking

7 Replies

Related content

Duplicate ranking

Ranking KPI card

Rank with conditions

Dynamic Ranking

What are community ranks?