RankX Measure to ignore slicer

SACooper — Mon, 17 Oct 2022 14:04:55 GMT

We have a scoreboard that shows our employee's their quality scores across different contact types (Email, Telephony, Face to Face as well as a Combined Score)

The Table (Quality) is defined with columns Date, Name, Assessment Type, Attritbute, Score_Acheive, Score_Potential

I have a variety of measures [Result] are defined as

VAR Numerator = CALCULATE(SUM(Quality[Score_Achieved]), Quality[Assessment Type] = "Email")

VAR Denominator = CALCULATE(SUM(Quality[Score_Potential]), Quality[Assessment Type] = "Email")

RETURN

If (Denominator = 0, 0 , DIVIDE(Numerator, Denominator))

for the different types of assessment and the following for the overall result.

VAR Numerator = SUM(Quality[Score_Achieved])

VAR Denominator = SUM(Quality[Score_Potential])

RETURN

If (Denominator = 0, 0 , DIVIDE(Numerator, Denominator))

We have a simple Dashboard with a date slicer and an employee slicer (with a manager/employee hierarchy so we can look at team performances) and then a guage that shows their performance to target, for each type of assessment (Email, Telephony, Face to Face and a Combined Result)

What i'd like to acheive is a ranking measure that would essentially allow the employee to see that they are position X of Y employee's for that assessment Type.

The closest i've got is

Ranking =

RANKX(

ALLSELECTED( Quality), CALCULATE( DIVIDE( SUM(Quality[Score_Achieved]), SUM( Quality[Score_Potential])), ALL( Quality[Assessment Completed For:])),,DESC,Dense

)

Which If I put employee, Score and this measure into a table returns the correct values - when I then add this to the dashboard a different figure is returned. It looks like its being affected by the employee slicer -- and i've not figured out a way to change it so it ignores this...

Any help would be really apprecaited.

Re: RankX Measure to ignore slicer

amitchandak — Mon, 17 Oct 2022 14:52:14 GMT

SACooper , if you do not filter to change to all

Ranking =

RANKX(

all( Quality), CALCULATE( DIVIDE( SUM(Quality[Score_Achieved]), SUM( Quality[Score_Potential])), ALL( Quality[Assessment Completed For:])),,DESC,Dense

)

But remember any column not covered by the Table expression in rank, rank will distribute inside that

For Rank Refer to these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

Re: RankX Measure to ignore slicer

SACooper — Mon, 17 Oct 2022 15:00:35 GMT

Hi amitchandak Thank you for looking at this, unfortuantely this doesn't appear to be working, ranks everyone as 2 in the test table -- and does the same for the visuals when added as a tooltip.

topic RankX Measure to ignore slicer in DAX Commands and Tips

RankX Measure to ignore slicer

Re: RankX Measure to ignore slicer

Re: RankX Measure to ignore slicer