AllSelected inside AllExcept

[GuillaumeBD]

Hello, I have the measure below to calculate the average price by catergory.

I have a filter on Address that I would like to be applied to the measure as well so that "Avg_Cat" changes if I remove/add adresses (See second print screen). I tried a bunch of stuff including adding AllSelected, but I couldn't make it work and the "Avg_cat" always stays the same. Thank you

Avg_Cat =
AVERAGEX ( ALLEXCEPT ( Houses, Houses[Category] ), [Price_] )

Data Source

[GuillaumeBD]

Thank you!

[DataInsights · Accepted solution]

@GuillaumeBD,

Try this measure:

Avg_Cat = 
CALCULATE ( AVERAGE ( Houses[Price] ), ALLSELECTED ( Houses ), VALUES ( Houses[Category] ) )

[GuillaumeBD]

Hello @DataInsights , I made a few changes and I can't find the new solution. Here's my new problem.

I have a filter "Price" and a filter "Category". What I want to do is be able to select the filter category with Avg_cat staying the same. I only want Avg_Cat to change if I modify the filter "Price" (the value resulting with the price filter should be the same with or without the category filter selected).

Thank you