Trying to filter with allexcept/removefilters

[michaelu1]

I have the following data for our properties:

Entity Group	Regional	Property name
1	A	Red
1	A	Yellow
1	A	Green
1	B	Blue
1	B	Purple
2	C	Orange
2	C	Lemon
2	C	Pear
2	C	Apple
2	D	Kiwi
2	D	Plum

I created a measure to give me averages based off whatever filters are placed on this table.

I also created an 'entity' measure that will give me an average for the entity disregarding any filters on the other columns.

The issue that I'm having now, is that occasionally I will need to remove a property from the 'entity' measure, meaning show me the average for entity 1 without red. I can't seem to figure out how to do that. I tried adding it to the formula by saying keep the filters on entity and property, but then when I filtered by regional the second measure updates as well.

I think is that same thing from a different persective - I also need the ability to filter the property column at the same time. Meaning I would want to see the average for yellow (first measure) compared to the average of its entity without red (second measure).

[v-kkf-msft]

Hi @michaelu1 ,

Even if you only keep the filter for the [Property name] column, once a selection is made on [Regional], it will actually pass the filter to the [Property name] column, which in turn will filter the measure.

The workarounds are:

1. Put the [Regional] column and the [Property name] column in separate tables and use the allexcept/removefilters functions.

2. Turn off the interaction between the [Regional] column and the measure.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

In the Filter pane, just filter out Red.  Your simple average measure should show the correct number.

[lbendlin]

show your work and indicate the expected outcome based on your sample data.