How can i filter by a measure

[Anonymous]

Hi everyone, i have this table in Pbi: 

First column is number of week. Seventh column is elasticity (measure), last column is a measure that i want to use to filter elasticity.

I want to calculate the average elasticity when "filter elasticidades grandes" measure = "Si considerar".

My average is now not considering the filter "Si considerar". 

Now, my measure to calculate the average elasticity is : 

Promedio elasticidad = AVERAGEX(VALUES(Combinar1[Numero semana]),[Elasticidad])

I suposse i have to change VALUES to other thing but i dont know which change i have to do.

Thanks.

[amitchandak · Accepted solution]

@Anonymous , One is use visual level filter

another one is to try a measure like

Promedio elasticidad = AVERAGEX(Filter( VALUES(Combinar1[Numero semana]) ,  [Si considered] <.1 ) ,[Elasticidad])

[Anonymous]

What do you refer with visual filter?

[Anonymous]

Ty very much, i used your measure, but i had to change one thing:

Promedio elasticidad Pbi comn = AVERAGEX(Filter( VALUES(Combinar1[Numero semana]) , [Filter Elasticidades Grandes] = "Si considerar" ) ,[Elasticidad])