DAX Calculation - Using MAX Issue

#1

I am trying to troubleshoot a DAX Calculation Issue…

My original calc:

Current Show Sq. Ft. = CALCULATE([Total Sq. Footage], FILTER(Show, Show[showkey]=[Max Show Key]))

Renders the following value = 529K (see screen shot below)

but if type the number 47 in place of the [MAX SHOW KEY] it renders 167??

** WHY IS THAT?

[Max Show Key] computes to 47

Original
Original.png1407×500 25.8 KB
Updated
Updated.png1407×567 27.2 KB

#2

@mbraun
I have an idea, but would like to see if it works with your data. Possible to upload a sample?

Thanks,

Enterprise%20DNA%20Expert%20-%20Small

#3

Nick - Thanks for the response. Right after I submitted I got this to work…

Sq. Footage = CALCULATE ( [Total Sq. Footage], FILTER (SHOW, SHOW[SHOW_KEY]=MAX(SHOW[SHOWKEY]))

I am definitely having other issues but I will start a new thread for that.

#4

Yes that’s right here it will all be to do with the context of the calculation within the FILTER function.