Forum Discussion
How to use SUMX and VALUES with multiple filter columns?
Hi, I am using a formula to create the SUM of a measure: Total Underutilisation = IF(HASONEVALUE([servername]), [Underutilisation], SUMX(VALUES([servername]), [Underutilisation])) I actuall...
Hi Anonymous ,
You could try to use UNION() function
SUMX(UNION(VALUES('Table'[Column1]),VALUES('Table'[Column2])),[measure])Best Regards,
Jay
Hi Anonymous ,
You could try to use UNION() function
SUMX(UNION(VALUES('Table'[Column1]),VALUES('Table'[Column2])),[measure])
Best Regards,
Jay