Forum Discussion
AllSelected inside AllExcept
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
Try this measure:
Avg_Cat = CALCULATE ( AVERAGE ( Houses[Price] ), ALLSELECTED ( Houses ), VALUES ( Houses[Category] ) )
3 Replies
Try this measure:
Avg_Cat = CALCULATE ( AVERAGE ( Houses[Price] ), ALLSELECTED ( Houses ), VALUES ( Houses[Category] ) )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
Thank you!
