Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
It would seem a simple question, but I can’t solve it in Power BI...
You can get pbix exampe via this link (unfortunately direct loading is not available for me in this forum):
https://www.dropbox.com/s/vmt0z7n8ai3phgq/DAX%20Issue%20Example%202.pbix?dl=0
In this example I'm getting zero values for the totals of columns Effect and MixEffect:
But I need get 130 (35 + 50 + 45) and 830 (140 + 150 + 540).
This example is based on the following simple data:
Solved! Go to Solution.
@ikibirev you can write these two measures
_effect = SUMX(VALUES(TestTable[Category]),[Effect])
_effect = SUMX(VALUES(TestTable[Category]),[Effect])
@ikibirev you can write these two measures
_effect = SUMX(VALUES(TestTable[Category]),[Effect])
_effect = SUMX(VALUES(TestTable[Category]),[Effect])
Greate! You are Superb!
The formula in your answer was slightly not exactly copy-pated, but I got the idea. Merged this answer with ValtteriN answer.
So the result formulas are:
Thank you very much!
Hi,
The total of a matrix uses the same logic as with the measure in the column. To create a custom total which calculates all of the values you can use SUMX and IF.
Here is a very similar solution to your case:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Total-wrong/m-p/2268244#M55107
The basic dax is as follows:
Proud to be a Super User!
A very interesting idea! But unfortunately the result is different from zero, but has the wrong value (1450 instead 830):
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
9 | |
9 | |
6 | |
5 |
User | Count |
---|---|
19 | |
18 | |
11 | |
9 | |
9 |