Hi,
I am using a formula to create the SUM of a measure:
Solved! Go to Solution.
Hi @powerbi11111 ,
You could try to use UNION() function
SUMX(UNION(VALUES('Table'[Column1]),VALUES('Table'[Column2])),[measure])
Best Regards,
Jay
Hi @powerbi11111 ,
You could try to use UNION() function
SUMX(UNION(VALUES('Table'[Column1]),VALUES('Table'[Column2])),[measure])
Best Regards,
Jay
@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]))
Hi,
The two columns are from different and unrelated tables
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
User | Count |
---|---|
209 | |
51 | |
43 | |
41 | |
39 |
User | Count |
---|---|
270 | |
210 | |
73 | |
70 | |
65 |