REMOVEFILTERS... But not completely...

[Fraze]

I am trying to create a column that only displays the aggregate calcualtion for the rows that have not been filtered out; without including the data that has been. 

Typically I would just use REMOVEFILTER, but in this case, the filter is still important to me... 

NewRtl/UsedRtl = DIVIDE([New],[Used])

NewRtl/UsedRtl Agg = CALCULATE(DIVIDE([New],[Used]),REMOVEFILTERS(Companies'))

Test #1 - When including all stores with no company filter, it does exactly what I want...

Test #2 - But when I filter out half the stores, as expected the Agg column stays 1.1, but WHAT I WANT is every row to say is 1.3...

Curious how I can construct a statement that will give me a column that returns the aggregate total for all stores that have not been filtered out.

Thanks!

[bolfri · Accepted solution]

Have you tried  CALCULATE(DIVIDE([New],[Used]),ALLSELECTED(Companies')) ?

[Fraze]

That worked like a charm. Didn't know thats how ALLSELECTED worked.

Thanks!