Forum Discussion
Use Measure as Filter
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
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
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.
Yes rpinxt ,
It is exactly as you said.