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