Forum Discussion

GuillaumeBD's avatar
GuillaumeBD
Frequent Visitor
2 years ago
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...
Need Help
Tips and Tricks
  • DataInsights's avatar
    DataInsights
    2 years ago

    GuillaumeBD,

     

    Try this measure:

     

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

     

     

DataInsights's avatar
DataInsights
Super User
2 years ago

GuillaumeBD,

 

Try this measure:

 

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

 

 

GuillaumeBD's avatar
GuillaumeBD
Frequent Visitor
2 years ago

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