cancel
Showing results for
Did you mean:
Regular Visitor

## 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 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?

1 ACCEPTED SOLUTION
Community Support

You could try to use UNION() function

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

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
3 REPLIES 3
Community Support

You could try to use UNION() function

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

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Super User IV

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

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

Proud to be a Super User!

Regular Visitor

Hi,

The two columns are from different and unrelated tables

Announcements

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.