topic Re: How can i filter by a measure in DAX Commands and Tips

How can i filter by a measure

Anonymous — Wed, 10 Aug 2022 21:43:34 GMT

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.

Re: How can i filter by a measure

amitchandak — Thu, 11 Aug 2022 04:55:14 GMT

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])

Re: How can i filter by a measure

Anonymous — Thu, 11 Aug 2022 13:51:11 GMT

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])

Re: How can i filter by a measure

Anonymous — Thu, 11 Aug 2022 13:52:08 GMT

What do you refer with visual filter?