Forum Discussion
Calculation Group Condiftional Formatting not working
I think I've figured out why this was not working but I dont fully understand the why.
The calculation items I am trying to apply the formatting to are difference calculations so for example TY-PY. In the calculation I was using the format:
SELECTEDMEASURE()-
CALCULATE(
SELECTEDMEASURE(),
'calcgroup'[calcitem] = "PM")
I noticed that when I changed to the process in the video shared by parry2k (thanks) that the measures which didnt reference other calculation items were working correctly. So I changed the second part of the above formula to just do the calculation for PM and not reference the other calculation item and...
IT WORKS!Like I said, I dont really understand why it works this way and not the other, but whatever works. Now to change all my calculations items!
I think I've figured out why this was not working but I dont fully understand the why.
The calculation items I am trying to apply the formatting to are difference calculations so for example TY-PY. In the calculation I was using the format:
SELECTEDMEASURE()-
CALCULATE(
SELECTEDMEASURE(),
'calcgroup'[calcitem] = "PM"
)
I noticed that when I changed to the process in the video shared by parry2k (thanks) that the measures which didnt reference other calculation items were working correctly. So I changed the second part of the above formula to just do the calculation for PM and not reference the other calculation item and...
IT WORKS!
Like I said, I dont really understand why it works this way and not the other, but whatever works. Now to change all my calculations items!