Use Measure as Filter

[rpinxt]

Can somebody explain why I cannot use a measure as filter on the whole page (or all pages) but only on the separate visuals on that page?

So I have 2 visuals on that page that both can be controlled by that filter measure I made.

But I have to put it in both visuals separate. I wanted do it only 1 time on the page but PBI would not let me.

[MohammadLoran25 · Accepted solution]

Hi @rpinxt 

Putting a filter on "Filter on all Pages" section of FilterPane means that it would affect all the visuals of all pages.

If you put a measure as filter on all pages, what does it mean? A measure is a calculation which is done based on the context. And Context is defined once you put the measure in a Visual.

For Example, if you set the Sales Quantity measure to greater than 100 on all pages (assume power bi allows you), how should it behave and filter the visuals?  If you have a card, the card value is made up of the SUM over different fields, how power bi should implement your filter on the card? and also the other visuals is the same as well. So it is meaningless.

If this answer solves your problem, please mark it as an accepted solution so the others would find what they need easier.
Regards,
Loran

[rpinxt]

I do understand what you are saying.

In this case the measure would work for all the visuals on the page.

However I agree there would be need of a general rule which would work in all cases.

Also the case when one of the visuals cannot be filtered by that measure.

So I guess as a thumb of rule. You can only filter on page(s) with fields from the table. Not with measures.

[MohammadLoran25]

Yes @rpinxt ,

It is exactly as you said.