Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Try this measure:
Avg_Cat =
CALCULATE ( AVERAGE ( Houses[Price] ), ALLSELECTED ( Houses ), VALUES ( Houses[Category] ) )
Proud to be a Super User!
Thank you!
Try this measure:
Avg_Cat =
CALCULATE ( AVERAGE ( Houses[Price] ), ALLSELECTED ( Houses ), VALUES ( Houses[Category] ) )
Proud to be a Super User!
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