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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors