CM % values are not coming correctly in matrix visual

[Anonymous]

I have budget and actual values in the matrix view , to show delta which is( budget-actua) in the the martrix visual i have create an UNION table . When i started doing calculations on combined table the results are getting wrong.

Created a measure named gross revenue (simple sum of values column), the values are showings correctly in all the three scenarios..but i when i create another measure named CM% which is division of two measures ( contribution/gross revenue) the values showing wrong in actual budget and delta

[v-diye-msft]

Hi @Anonymous 

you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.

[parry2k]

@Anonymous what are the measures expression your used in calculation of CM% 

[Anonymous]

Gross revenue = CALCULATE(SUM(uniontable(values)),uniontable(account)="Gross revenue"

Contribution =CALCULATE(SUM((uniontable(values)),uniontable(account)="Contribution"

Cm%= DIVIDE(Contribtuion,gross revenue)