Forum Discussion

mikemagill's avatar
mikemagill
Icon for Helper I rankHelper I
1 year ago
Solved

Calculation Group impact on other measures

I posted about this problem in another post and found a work-around but could really do with understanding this properly. When I create a calculation group, use that calculation group in a slicer ...
Need Help
  • johnt75's avatar
    johnt75
    1 year ago

    This is expected behaviour. The slicer will apply to all visuals on the page unless you turn it off through Edit Interactions. Calculation items are applied to all measures, and so when you choose one in the slicer it will be applied to the test measure.

    You can change which measures the calcultion item affect by putting checks in the calc item code using  functions like SELECTEDMEASURENAME or ISSELECTEDMEASURE.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

This is expected behaviour. The slicer will apply to all visuals on the page unless you turn it off through Edit Interactions. Calculation items are applied to all measures, and so when you choose one in the slicer it will be applied to the test measure.

You can change which measures the calcultion item affect by putting checks in the calc item code using  functions like SELECTEDMEASURENAME or ISSELECTEDMEASURE.

  • mikemagill's avatar
    mikemagill
    Icon for Helper I rankHelper I
    1 year ago

    Perfect.  That's what I was missing.

    I can now limit the scope of my calculated items.  I've used code similar to the following:

    Group Min =
        IF(
            ISSELECTEDMEASURE([Placeholder Measure]),
            [Min],
            SELECTEDMEASURE()
        )