[Calculation Group] showing PY and CY in matrix when one option is selected on slicer

[szczawekk]

I have simple model fact and comparison (Dim).

Due to performance issue fact was design with duplicated rows. each period has value for (1) CY and (2) PY.
i created calucation group that is calculating value for CY and PY as:

CY = 
CALCULATE(
    SELECTEDMEASURE(),
    REMOVEFILTERS(Comparison[ComparisonId]),
    Comparison[ComparisonId] = 1
)

It works but when i add it to matrix as below, when Comparison from dim is selected, then other value is hidden (in this case when CY is selected PY is hidden).

Is there option to force CG to ignore comparison selection? So regardeles slicer selection always CY and PY will be visible? Switching of interaction is not an option due to page requirement and other measures presented in the matrix (CY, PY, delta, % change, calculation related to CY or PY based on selection)
currently when slicer value is selected the other one goes blank

[bhanu_gautam · Accepted solution]

@szczawekk To ensure that the slicer selection does not affect the visibility of CY and PY, you can try using the ALL function within your calculation group definitions

CY =
CALCULATE(
SELECTEDMEASURE(),
ALL(Comparison[ComparisonId]),
Comparison[ComparisonId] = 1
)

PY =
CALCULATE(
SELECTEDMEASURE(),
ALL(Comparison[ComparisonId]),
Comparison[ComparisonId] = 2
)