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! It's time to submit your entry. Live now!
I have an issue with my measure calculating properly for my total when I add my measure to my matrix visual. I can't figure out why its not calculating properly as my total is 267,341,999 when it should be 271,499,454.
If you were to add each row's months together you will get a different total than what is displayed. For example, row 1 the total displayed shows 13,790,209 but when manually adding together Jan - Dec for row 1 you get 14,000,001.
When you manually add together the total row for each month (Jan - Dec) you get 271,499,454 but the visual displays 267,341,999.
Example data tables to help me in solving this issue.
Dim_Budget table: https://drive.google.com/file/d/1StViE09SQLuoE2qLoM3oSKua4jgr8WU9/view?usp=drive_link
Dim_Dates Table: https://drive.google.com/file/d/1_41UfZCCHE5BJFVc4a0Pbx7LM8fyfDFp/view?usp=drive_link
This is the measure I am using. The dataset is only showing Gross Revenue in my budget table but I have other categories which is why I have the measure filtering for just "Gross Revenue"
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 61 | |
| 48 | |
| 35 | |
| 25 | |
| 23 |
| User | Count |
|---|---|
| 134 | |
| 110 | |
| 59 | |
| 39 | |
| 32 |