Solved: Re: How to use SUMX and VALUES with multiple filte...

powerbi11111 · ‎03-25-2021

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?

v-jayw-msft · ‎03-31-2021

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.

v-jayw-msft · ‎03-31-2021

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.

amitchandak · ‎03-26-2021

@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]))

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

powerbi11111 · ‎03-28-2021

Hi,

The two columns are from different and unrelated tables

How to use SUMX and VALUES with multiple filter columns?