cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vichus Member
Member

Include a measure in the visual level filter.

Screenshot (6).png

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.

1 ACCEPTED SOLUTION

Accepted Solutions
BILASolution Established Member
Established Member

Re: Include a measure in the visual level filter.

Hi @vichus

 

I have a table "Sales"

 

m.png

 

 

"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.

nnnn.png

 

 

I hope this helps

 

BILASolution

3 REPLIES 3
BILASolution Established Member
Established Member

Re: Include a measure in the visual level filter.

Hi @vichus

 

I have a table "Sales"

 

m.png

 

 

"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.

nnnn.png

 

 

I hope this helps

 

BILASolution

Community Support Team
Community Support Team

Re: Include a measure in the visual level filter.

Hi @vichus,

 

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

Include a measure in the visual level filter.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Include a measure in the visual level filter.

Hi @vichus,

 

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.