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
@mbraun
I have an idea, but would like to see if it works with your data. Possible to upload a sample?
Thanks,
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.
Yes that’s right here it will all be to do with the context of the calculation within the FILTER function.
