Static calculation independent on hierarchical slicing

[Jensk]

I need to slice by a hierarchy of entities that consists of companies that each have their customers. I can look at numbers for the Entity or for a Company within the Entity:

My Measures:

Revenue = SUMX( Sales, Sales[Amount] * Sales[Price] )

Revenue Entity = CALCULATE( [Revenue], ALLSELECTED(), VALUES(Sales[Entity]))

Now when I select a company, I would want my 'Revenue Entity' to remain unchanged but it is not:

What is wrong with my 'Revenue Entity' measure? I would think the ALLSELECTED() removed the filter context and calculate by Entity. I need it to calculate the revenue for all companies that have the same entity as the selected company. In my data customer3 and customer4 only have revenue in company2.

[melanid]

Hi, 

Good ! I may have an other idea, you need to specify the column for the function ALLSELECTED(). Maybe if you try ALLSELECTED(Company) or ALL(COMPANY) ?

Best regards,

[melanid]

Hi,

Did you try the REMOVEFILTERS() function? 

Maybe something like REMOVEFILTERS(Customer) will work (instead of ALLSELECTED). 

Best regards,

[Jensk]

Thanks for the suggestion.
Using REMOVEFILTERS(Sales[Customer]) instead of ALLSELECTED() yields the same result.
Using REMOVEFILTERS(Sales[Company]) instead of ALLSELECTED() yields the same result for rows, but the total is correct.