Confusing DAX measure behavior

[tusmo]

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:

SUMX(Table;
  VAR var_1 = CALCULATE([measure_1])
  VAR var_2 = CALCULATE([measure_2])

  RETURN var_1 * var_2

)

So basically for each row of Table I want to calculate measures_1 and measure_2 after transitiong the row context into a filter context and then multiply them. My problem is that right now this measure is always giving me BLANK. However if I define measure:

SUMX(Table;
  VAR var_1 = CALCULATE([measure_1])
  VAR var_2 = CALCULATE([measure_2])

  RETURN var_1

)

Everything works fine, and if I do: 

SUMX(Table1;
  VAR var_1 = CALCULATE([measure_1])
  VAR var_2 = CALCULATE([measure_2])

  RETURN var_2

)

Everything also works fine. Fine meaning that both measures return non-BLANK decimal values when the original only returns BLANK. This goes against everything I thought I understood about DAX. How can both var_1 and var_2 seem to evaluate to non-BLANK values in the exactly same context but when I take the product everything goes BLANK?

[Barnee]

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