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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.