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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Visual total correct but rows dont add up

Hi

 

In my visual below I am showing the Balance as at Feb20 my first column and the movement amounts in the next 3 columns.

 

The grand total for the movement columns are correct, and the sum of the rows for these columns add up to the correct grand total.

 

However, for the balance column, the rows dont add up to the grand total which is the correct amount i.e. 10.2m is the correct total, but the sum of the rows for the balance column is like 2m. It is like there are rows missing..

 

Please can you advise? See detail below.

 

FAC Claims debtors screenshot.png

 

Here are my Measures: 

 

FAC Claims Debtors move:=CALCULATE(SUM('RICLAIMSDEBTORS'[AmountInclVAT]),RICLAIMSDEBTORS[RI Type Group]="FAC")

FAC Claims Debtors close ALL:=
VAR CumulativeTotal = CALCULATE([FAC Claims Debtors move],
FILTER(ALL('SSAS V_DIM_AccountingPeriod - ReportingPeriod'),'SSAS V_DIM_AccountingPeriod - ReportingPeriod'[ReportingDateEnd]<=MAX('SSAS V_DIM_AccountingPeriod - ReportingPeriod'[ReportingDateEnd]))
)
RETURN
IF(ISBLANK([FAC Claims Debtors move]),BLANK(),CumulativeTotal)

5 REPLIES 5
Anonymous
Not applicable

HI @Anonymous,

Can please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

In addition, you can also take a look at the following blog to know more about measure total level calculations:

Measure Totals, The Final Word  
Regards,

Xiaoxin Sheng

Anonymous
Not applicable

@amitchandak 

 

It seems to be related to my other issue below where there should only be rows for "FAC"..

 

FAC Claims debtors screenshot4.pngFAC Claims debtors screenshot3.png

amitchandak
Super User
Super User

@Anonymous , where is balance formula ?

 

Try this like


FAC Claims Debtors close ALL:=

 CALCULATE([FAC Claims Debtors move],
FILTER(ALL('SSAS V_DIM_AccountingPeriod - ReportingPeriod'),'SSAS V_DIM_AccountingPeriod - ReportingPeriod'[ReportingDateEnd]<=MAX('SSAS V_DIM_AccountingPeriod - ReportingPeriod'[ReportingDateEnd]))
)

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Hi @amitchandak

 

See below:

 

Looks like ours is the same..

 

FAC Claims debtors screenshot2.png

@Anonymous , I want isblank to removed. that will can lead to grand total issue. But I am not sure in this case 

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.