Forum Discussion

tusmo's avatar
tusmo
Frequent Visitor
8 years ago

Confusing DAX measure behavior

Hi,   Sorry for the vague variable names but I'd rather not reveal too many details. I'm kind of new to DAX and the problem I'm having is that I have defined a measure that looks like this:   SUM...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi tusmo,

since I don't really see the context of the calc here it's going to be a blind guess based on the syntax of the calc.

I might would try to define the variables at the begining of the calc and then write the SUMX part after the RETURN
Like this:

Measure 3 = VAR var1 = CALCULATE([Measure])
            VAR var2 = CALCULATE([Measure 2])
RETURN
SUMX(Table1,var1*var2)

Bests,

Barna