Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have this calc col -> Punctuality = IF (OTIF[ShiftInTime]<OTIF[TimeFrom]-1/24*.25,"Early",
IF (OTIF[ShiftInTime]>OTIF[TimeFrom]+1/24*.25,"Late","On Time"
& IF (OTIF[ShiftInTime]>OTIF[TimeFrom]+1/24*1,"Perfect")))
I have this measure -> targetperc OT = LASTNONBLANK('OT%'[OT%],0.25)
I substitute the *.25 in th calc col with * targetperc OT to give me ->
Punctuality = IF (OTIF[ShiftInTime]<OTIF[TimeFrom]-1/24*[targetperc OT],"Early",
IF (OTIF[ShiftInTime]>OTIF[TimeFrom]+1/24*[targetperc OT],"Late","On Time"
& IF (OTIF[ShiftInTime]>OTIF[TimeFrom]+1/24*1,"Perfect")))
I have applied the values in OT% table to a slicer. However, when I select values in the slicer, nothing changes. Below is the table my measure is using.
What am I missing here?
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |