Grand Total Error

[Anonymous]

Hello All,

I've been trying to track down an answer to my totaling issue for a specific set of data im looking at. I know the error has something to do with filters possibly in the background, but was wondering if there is a way to work around it.

Essentially, have this specific set of accounts with a value attached filtered down from a larger data set. The "Total Row" is not summing up the rows above it properly. I'm sure BI is working properly, but I just need a formula to take the value and sum it up correctly as it is displayed above. The correct value should be 1847, but it keeps displaying 1204.

This is how the data is currently being displayed in BI:

Acct                         Value

1                            248

2                            293

3                            180

4                            48

5                            238

6                            592

7                            0

8                            55

9                            113

10                          80

TOTAL                   1204

Any help on this matter would be greatly appreciated.

Thanks. 

[v-cherch-msft]

Hi @Anonymous

Below are some similar posts for your reference.You may change your measure to get the correct total.

https://community.powerbi.com/t5/Desktop/Switch-DAX-rebate-based-on-cumulative-measure/m-p/514547#M240481

https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Regards,

Cherie

[HotChilli]

You'll have to post the DAX for any measure that shows what data you're displaying.  We can't just look at it and say : "try this"