Forum Discussion
Robert14358
2 years agoResolver III
SUMX not working for variable table
Hello All im am having issues with totals in my matrix not summing up my columns properly. this is my DAX: AC Hrs (PW) = VAR SSMAXDATE = [Date Selection (MAX) SS] VAR MINDATE = [Date Select...
Ashish_Mathur
2 years agoSuper User
Hi,
Assuming Act_Key is the first column of your Table visual, see if this measure works
Measure = SUMX(Dim_Act[Act_Key],[AC Hrs (PW)])