Calculate the rate for the staff that dont reach target

[Anonymous]

Hi,

I'm trying to get DAX to calculate the rate for staff that dont reach target.

Example table:

Staff  | Rate

A       | 60

B       | 40

C       | 100

D       | 50 

The rate is actually a measure. And the target is 90. So i want to calculate the rate again but this time only for staff A, B and D only.

I need to sort out who dont reach the target first by comparing with the target and recalculate the rate for failed staffs.

[DOLEARY85]

Hi,

if you ony want to calculate the rate of Staff under 90 you could use an if statement in the measure:

if(  Current Measure < 90, Current Measure, Blank())

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍