cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
powerbi11111
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
v-jayw-msft
Community Support
Community Support

Hi @powerbi11111 ,

 

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.

View solution in original post

3 REPLIES 3
v-jayw-msft
Community Support
Community Support

Hi @powerbi11111 ,

 

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.

View solution in original post

amitchandak
Super User
Super User

@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!

Hi,

 

The two columns are from different and unrelated tables

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!