Forum Discussion
Solved
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 remov...
Try this measure:
Avg_Cat = CALCULATE ( AVERAGE ( Houses[Price] ), ALLSELECTED ( Houses ), VALUES ( Houses[Category] ) )
Thank you!