Forum Discussion

dange187's avatar
dange187
Frequent Visitor
2 years ago
Solved

Calculation Group Condiftional Formatting not working

I have a model where I have 1 calculation group for time intelligence. I am using it in a matrix so users can select what time intelligence options they see via a slicer for the calculation group. I ...
Need Help
  • dange187's avatar
    dange187
    2 years ago

    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!