DAX VAR defining named variables in the middle of the measure code

Question

Here,I am defining in the middle of the DAX code

Expected Result =
SUMX (
    VALUES ( Unique_Manager[Manager] ),
    VAR SumBrand = CALCULATE ( SUM ( Budget_Brand[BudgetBrand] ) )
    VAR SumProduct = CALCULATE ( SUM ( Budget_Product[BudgetProduct] ) )
    RETURN
        IF ( ISBLANK ( SumProduct ), SumBrand, SumProduct )
)

where this measure works

Measure_good = CALCULATE( 
    SUM(table[Amount]) 

) 

and this doesnt works

Measure_bad = CALCULATE( 
    VAR inside_measure = SUM(table[Amount])
)

 What are the rules of VAR?

Answer 1

Use the following measure

Measure_bad = CALCULATE( 
    VAR inside_measure = SUM(table[Amount])
    RETURN
    inside_measure
)

Want to learn more about Power Bi, Refer & learn Power bi

Also, check out our YouTube video to know the data visualization basics and best practices with Power BI