Calculate the total based on different percentage

[wouterDefour]

Hello,

I have follwing data:

Category	Calculated Yield	Volumes	Volume %	AlternateVolume %	AlternateResult
A	98	100	0,3	0,2	19,6
B	95	200	0,5	0,7	66,5
C	99	50	0,1	0	0
D	100	20	0,1	0,1	10
Total	96,62	370	1	1	96,1

Notice that Alternate result is what I want, but not what PBI calculates.

I would like PBI to calculate the yield (coulumn 2), depending on the alternative percentages ( column 5).

The result now I get as AlternativeResult is the same as "total of calculated yield", as I assume PBI multiplies 96.62 by 1.

I would like PBI to calculate the total as: sum( yield by category * % alternative percentage ) 

Is it possible to achieve this?

Thanks!

Best regards,

Wouter Defour

[Tanushree_Kapse · Accepted solution]

Hi @wouterDefour ,

Please find the below image the measures:

Result = SUM('Table (4)'[Calculated Yield]) *SUM('Table (4)'[AlternateVolume %])

ResultActual = SUMX(VALUES('Table (4)'[Category]),[Result])

I hope this helps!

If I answered your question, please mark this as a solution. Kudos are always appreciated!

Thanks.

[wouterDefour]

Thanks for the help!