Summarize doesnt work when VARs are in it

[PbI_Fox]

Hello,

I have issues with what i think is the order of VAR calculations in my measure.

The code here works:

NDR_WC =
VAR WC_Table =
    SUMMARIZE (
        Astute_Export,
        Astute_Export[EmployeeID],
        "TableWC", CALCULATE (
            IF (
                ISBLANK (
                    CALCULATE ( SUMX ( Astute_Export, [NDR_WC1] ), Astute_Export[Type] = "Oncost" )
                ),
                CALCULATE ( SUMX ( Astute_Export, [NDR_WC1] ), Astute_Export[Type] = "Payment" ),
                CALCULATE ( SUMX ( Astute_Export, [NDR_WC1] ), Astute_Export[Type] = "Oncost" )
            )
        )
    )
RETURN
    SUMX ( WC_Table, [TableWC] )

However if i change line 9 CALCULATE function in to a var, for example, it stops working and is giving me the wrong number. How to make this code work?

NDR_WC =
VAR Oncost_WC_Calc =
    //Calculates WC existing in OnCost sections
    CALCULATE (
        SUMX ( Astute_Export, [NDR_Step1] ),
        Astute_Export[Type] = "Oncost"
    )
VAR Payment_WC_Calc =
    //Calculates WC existing in Payment sections
    CALCULATE (
        SUMX ( Astute_Export, [NDR_Step1] ),
        Astute_Export[Type] = "Payment"
    )
VAR WC_Table =
    SUMMARIZE (
        Astute_Export,
        Astute_Export[EmployeeID],
        "TableWC", IF ( ISBLANK ( Oncost_WC_Calc ), Payment_WC_Calc, Oncost_WC_Calc )
    )
RETURN
    SUMX ( WC_Table, [TableWC] )

[harshnathani]

Hi @PbI_Fox ,

When a variable is calculated and stored, it is static.

https://community.powerbi.com/t5/DAX-Commands-and-Tips/VARs-inside-SUMMARIZE-dont-work/m-p/1266694#M...

Regards,

Harsh Nathani

[lbendlin]

Think about what you want to achieve, and then investigate how your context modifiers may mess with it.  VARs help you to avoid some modifiers'  impact, but they can also enforce the impact. If you are falmiliar with the EARLIER() function - that's basically what VARs do - they provide you a snapshot of an "earlier" context.

There's a secondary function that VARs fulfill, and it's an ironic one. They help you to avoid calculating the same thing multiple times, and in that respect they are actually constants, not variables.    But that part is not overly applicable to your situation.