How to use SUMX and VALUES with multiple filter columns?

[Anonymous]

Hi,

I am using a formula to create the SUM of a measure:

Total Underutilisation = IF(HASONEVALUE([servername]), [Underutilisation], SUMX(VALUES([servername]), [Underutilisation]))

I actually have two fields filtering the calculated Underutilisation, the servername as well as the accountname.

How do I incorporate more than one column into the VALUES field to calculate the real SUM?

[Anonymous · Accepted solution]

Hi @Anonymous ,

You could try to use UNION() function

SUMX(UNION(VALUES('Table'[Column1]),VALUES('Table'[Column2])),[measure])

Best Regards,

Jay

[amitchandak]

@Anonymous , You can use summarize when you have more than one column

IF(HASONEVALUE([servername]), [Underutilisation], SUMX(Summarize(Table,[servername],Table[Groupbytwo], "_1", [Underutilisation]),[_1]))

[polymathy2017]

He clearly asked how to use SUMX and VALUES in the same measure.

[Anonymous]

Hi,

The two columns are from different and unrelated tables