Forum Discussion
Calculation Groups- More Than One Measure For Each Calculation Item
I think this can be avoided by using if within the calculation group.
So if you include this logic in the calculation items it should work:
IF(selectedmeasurename()="Name of calc grp",selectedmeasure(), Your original calculation item logic)Alternative option would be to make another calculation group which would have the logic I described above and assign its precedence to be before the original calculation group.
I think this can be avoided by using if within the calculation group.
So if you include this logic in the calculation items it should work:
IF(selectedmeasurename()="Name of calc grp",selectedmeasure(), Your original calculation item logic)
Alternative option would be to make another calculation group which would have the logic I described above and assign its precedence to be before the original calculation group.
It worked! You're awesome!
I have created another Calculation Group with 2 measures: Value and Target. I gave it precedence over the original group.
I have changed the calculated items this way- for example, Reviews:
IF(SELECTEDMEASURENAME()="Target",
[An expression that uses SELECTEDVALUE('MI Metric Selection'[Metric]) to get the Revies Target},
[Reviews])
Finally, in the visual I shared, I now plot the Value from this new calculation group (here it would return [Reviews]) and the Target. Perfect!