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.
Hi (by the way I love your report theme),
I am pretty sure calculation groups don't have anything like SELECTEDMEASURENAME, but as a workaround you could just use MAX('MI Metric Selection'[Name]) In you example it should return "Reviews".
I hope this helps to solce your issue and if it does consider accepting this as a solution!
Thank you- it's rather close, but not there yet.
MAX('MI Metric Selection'[Metric]) return a metric name when nothing is selected from the calculation group (e.g. disabling the filtering from "edit interactions"), but when a calculation item is chosen, this measure return the chosen metric's resault (a number) rather than the name.
I can't overcome this sticky, tenacious behavior that any measure that's affected by a calculation group returns it's value, but not name.
Solutions that work on DAX Studio don't work in the roeport itsels.
Even the Measure
Twelve = 12Returns the chosen calculated item when plotted together.
