Share of parent revenue

[Anonymous]

Hello,

I'm trying to calculate share of the revenue parent but have problem with denominator. When I use such a measure denomnator is summing values for all regions.

CALCULATE(SUM(TABLE1[Amount]),FILTER(ALLSELECTED(TABLE1),TABLE1[PL Item]="Rev0")

Can anybody advise?

Thanks

[Anonymous · Accepted solution]

I solved it using such a measure:
CALCULATE(SUM(TABLE1[Amount]),ALLEXCEPT(TABLE1,TABLE1[Region]),TABLE1[PL Item]="Rev0"