Total when ratio's are part of formula

[Steven-conance]

Trying to find the correct total here.

I'd like to see a total of 313, it being the sum of the rows. 

The 313 on row level is calculated as follows: 13,03% of revenues on this client * 2.400 total procured material in the month.

For grand total it's now calculating the total % revenue, being 14,29% * 2.400. 

I probably need to create a virtual table, and/or SumX, but I can't get it to work 😑 Please help me out here. 

[v-shex-msft · Accepted solution]

Hi @Steven-conance,

It seems like a common measure total level calculation issue which appear when you try to clause with multiple aggregation, you can take a look at the Greg’s blog to know how to handle this:

Measure Totals, The Final Word 

If the above also not help, can you please share some dummy data keep the raw data structure with expected results to test?

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Steven-conance]

yes it's a measure:

13,03% of revenues on this client * 2.400 total procured material in the month

[FreemanZ]

is [Procured materials allocated to client] a measure? How is it defined?