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
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! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |