Include a measure in the visual level filter.

[Anonymous]

Can I use a measure in a visual level filter. I have to display the products those have productSales above the average value avg .

I'm using DirectQuery,so the average value may change over time.

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

[v-jiascu-msft]

Hi @Anonymous,

You mean you want to add a measure as a value rather than a filter? I'm afraid we can do it only with filter TOPN. Please refer to: https://community.powerbi.com/t5/Desktop/Filter-by-a-measure/m-p/101130. 

Best Regards!

Dale

[BILASolution · Accepted solution]

Hi @Anonymous

I have a table "Sales"

"Avg" and ">Avg" are "calculated columns"

Avg = AVERAGEX(ALL(Products);Products[Sales]) 

> Avg = IF(Products[Sales] >= Products[Avg];">Average";"<Average")

You can use it to filter.

I hope this helps

BILASolution