Delinking Page Filters on few Visuals

Power BI
4

@brjeeth,

Sure thing. To make the example more specific to your use case I created an Ad Type column in the Sales table, and then put a page filter on selecting Commercial only. To override, it uses the same ALL concept as above, this time just removing the filter on Sales[Ad Type].

Here’s the measure used this time:

Override Page Filter Ad Type = 
CALCULATE(
    [Total Sales],
    ALL( Sales[Ad Type] )
)

and here’s what it looks like in the visuals:

image
image890×423 27.7 KB

I hope this gets you what you need. If not, just give a shout.

Full revised solution file attached .