Trying to multiply but the wrong total

[markt89]

Hi,

I am multiplying columns from two different tables and it calculates the row values correctly but it seems to give an incorrect grand total.

Any community posts i have seen have advised when this happens to calues from the same table but not if they are from 2 different.

Can anyone please shed some light on how to get around this?

[v-shex-msft]

HI @markt89,

According to your description, it sounds like a common measure total level calculation issue. For this scenario, you can refer to the following blog about measure total issue if helps:

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng

[daXtreme]

How to properly ask questions to get fast and to-the-point answers...

[vanessafvg]

you will need to give more information.

can you give the fields and tables you are using and display some sample data, really hard to answer this question without the details..  Summing the totals does not always give you the total of the rows in a table, it depends on how your data has been modelled and the detail of how you doing the calc.

provide sample data

can you also give a screenshot of the totals.

and a view of your relationships

[markt89]

Vanessafvg,

I understand here is some sample data and the measures that are getting the data.