Forum Discussion
saud968
Memorable Member
Memorable MemberGetting Top 5 base on DAX measure
I have two measures
Rank PCM Simple =
IF (
HASONEVALUE ( SUPPORT__CW_OPS_CES_CSAT_PARTNER_CARE_TEMP[SURVEY_OWNER_FULL_NAME] ),
RANKX ( ALL ( SUPPORT__CW_OPS_CES_CSAT_PARTNER_CARE_TEMP[SURVEY_OWNER_FULL_NAME] ), [Avg_CSAT_Score] )
)
Top 3 PCM =
IF(
HASONEVALUE(SUPPORT__CW_OPS_CES_CSAT_PARTNER_CARE_TEMP[SURVEY_OWNER_FULL_NAME]),
IF(
[Rank PCM Simple] <= 3,
[Avg_CSAT_Score],
BLANK()
)
)
Based on this I am getting the top 3 but i now need top 5 SURVEY_OWNER_FULL_NAME, however, no matter what I change in [Rank PCM Simple] <= 3 under the 2nd measure I am unable to get top 5.
3 Replies
- saud968
parry2k so I figured out the ranking and based on the ranking i changed the [Rank PCM Simple] <= 3 from this to [Rank PCM Simple] <= 20 and I got top 5. However, I want to add the survey count to be ranked as well. There is measure for the same as total response count.
Rank PCM Simple =IF (HASONEVALUE ( SUPPORT__CW_OPS_CES_CSAT_PARTNER_CARE_TEMP[SURVEY_OWNER_FULL_NAME] ),RANKX ( ALL ( SUPPORT__CW_OPS_CES_CSAT_PARTNER_CARE_TEMP[SURVEY_OWNER_FULL_NAME] ), [Avg_CSAT_Score] ))Top 3 PCM =IF(HASONEVALUE(SUPPORT__CW_OPS_CES_CSAT_PARTNER_CARE_TEMP[SURVEY_OWNER_FULL_NAME]),IF([Rank PCM Simple] <= 3,[Avg_CSAT_Score],BLANK()))
- technolog
Super User
I hope this message finds you well. I've noticed that this solution remain unresolved. If any of you have managed to find a resolution to the issue, I kindly request that you share your solution for the benefit of the entire community. Alternatively, if you're still facing challenges, please do let us know as well.
Your insights and updates will greatly assist others who might be encountering the same challenge.
