Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
BuckedUpJJP
New Member

Total Row Miscalculation

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.

 

BuckedUpJJP_0-1734106995416.png

 

 

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"

Daily Budget =
DIVIDE(
    CALCULATE(
        SUM(dim_budgets[Value]),
        dim_budgets[Budget Account] = "Gross Revenue"  -- Filter for Gross Revenue
    ),
    CALCULATE(
        COUNTROWS(dim_dates),
        ALL(dim_dates),
        dim_dates[Month] = MAX(dim_budgets[Month]) &&
        dim_dates[Year] = MAX(dim_budgets[Year])
    )
)
1 REPLY 1
danextian
Super User
Super User

danextian_0-1734159090848.png

 





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.