Si con selectedvalue

Hola, @Cloud11

De acuerdo con su descripción, creo que puede utilizar la función 'isfiltered' en medida.

Así:

Contribution Margin =
VAR Mth1 =
    SELECTEDVALUE ( SelMth_Current[Month] )
VAR yr =
    SELECTEDVALUE ( SelYr[Year] )
VAR Fcst1 =
    SELECTEDVALUE ( SelMth4[Actual] )
VAR Prod =
    SELECTEDVALUE ( Product_Grp[Product] )
VAR Reg =
    SELECTEDVALUE ( Region_Grp[Region] )
VAR MthVal1 =
    CALCULATE (
        SUM ( Profitability_Consolidation[Profit] ),
        Profitability_Consolidation[Period] = Fcst1,
        Profitability_Consolidation[Month] = Mth1,
        Profitability_Consolidation[Year] = yr,
        Profitability_Consolidation[Product] = Prod,
        Profitability_Consolidation[AccountGroup] = "Contribution Margin"
    )
VAR MthVal2 =
    CALCULATE (
        SUM ( Profitability_Consolidation[Profit] ),
        Profitability_Consolidation[Period] = Fcst1,
        Profitability_Consolidation[Month] = Mth1,
        Profitability_Consolidation[Year] = yr,
        Profitability_Consolidation[Product] = Prod,
        Profitability_Consolidation[Region] = Reg,
        Profitability_Consolidation[AccountGroup] = "Contribution Margin"
    )
RETURN
    IF ( ISFILTERED ( 'table'[Region] ), MthVal2 / 1000, MthVal1 / 1000 )

Si no resuelve su problema, por favor no dude en preguntarme.

Saludos

Janey Guo

Si este post ayuda,entonces considere Aceptarlo como la solución para ayudar a los otros miembros a encontrarlo más rápidamente.