cancel
Showing results for
Did you mean:
Continued Contributor

## Use Measure as Filter

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.

1 ACCEPTED SOLUTION
Solution Sage

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

3 REPLIES 3
Solution Sage

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

Continued Contributor

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.

Solution Sage

Yes @rpinxt ,

It is exactly as you said.

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors