can you help me out why my total in a matrix visual not show the correct values?

[Anonymous]

I have the following simple matrix visual. in the bottom for total I expect the amount around 28m not 245m. can you give me some ideas what should I check? whats goint wrong?

with direct query I reach a big Oracle data table where I filter the ledger name that you can see. I think I have total 40 ledger and I only want to use the attached 19. the ledger balance is correct it is a calculated measeure, and its looks correct. but I have no idea why the total show incorrectly.  any idea?

[amitchandak]

Can you share the formula?

[Anonymous]

thank you for the quick reply. which formula exactly? the usd balanc c pl? is a simple calulation balance * fx rate both is a decimal number.

I found this video: click 

i followed the steps and noticed for the total row I have a results in a false row and the ledger name all true

using the formula in the video I have the following error:

couldn"t load the data for this visual
the exception was reaised by the idatareader interface.
any idea how can i fix this erro? i check the formats and bot the same: decimal number

[Anonymous]

 I also check my fx rates and looks like its summarized in the following matrix view. how can I should I delete the total amount? maybe that is the problem.

[Anonymous · Accepted solution]

HI @Anonymous ,

It seems like a common measure total calculates issue, it will appear when you apply multiple aggregations on measure formula. For this scenario, I'd like to suggest you take a look at the following blog about measure total calculations:

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng

[amitchandak]

Can you share some sample data to test? But if you are multiple. You should prefer sum(a*b) over sum(a)*sum(b)