Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi experts,
I have two measures:
X:=CALCULATE([GesamtKassenAuslastung];ALLSELECTED(('Date')))and
y:= [x] - [GesamtKassenAuslastung]
but in y as a result I am seeing 0, I am expecting that I see the summation. What should I do, that I calculate the summation in the result:
There's nothing strange about this result. Indeed, the result should be 0. That's because in the total row [GesamtKassenAuslastung] is equal to CALCULATE([GesamtKassenAuslastung];ALLSELECTED(('Date'))). What's more, if you add up all the results for y in the rows, you'll get 0 as well. AS SHOULD BE.
@Anonymous Do you have any idea, how can I get my desired result?
Try like
y:=sumx(summarize(Table, Table[year],Table[Month],"_1", [x] - [GesamtKassenAuslastung]),[_1])
@Fariba1984 - This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 20 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 33 | |
| 31 | |
| 19 | |
| 12 | |
| 11 |