Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
tusmo
Frequent Visitor

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:

 

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?

 

1 REPLY 1
Barnee
Advocate IV
Advocate IV

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.