Measure To Ignore Page Filter

[Anonymous]

Hi

I have a measure:

Sales Budget (Risk) Trend = calculate(sum(Backlog[Sales Budget]),all(Backlog[ReportRank]))

And I have a page-level filter Report Rank = 1. Report Rank is showing me which Report Date is the most recent one.

On the other hand, I have the area chart on which I want to use Report Date on X-axis and Sales Budget (Risk) Trend on Y-axis. 

With this page-level filter Report Rank = 1, on the X-axis I see only the most recent date, whereas I should have seen more dates. Therefore, I wanted to use either all or removefilters, but none of them worked. They don't change anything...

Does anyone know how to fix it?

Left: Current Status (Wrong)

Right: Desired Output

[Anonymous]

Hi @amitchandak 

It's a pity... 

I have also tried your suggestion, but it doesn't work either.

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

In your scenario, there is no method to ignore page level filters for ReportRank field and Date field.

Reserve your original DAX formula to create Reports measure, remove ReportRank field field from page level filters, then create a slicer using ReportRank field. Click each slicer and select “Edit interactions” under Format ribbon, then select “None” for the visuals that you use Reports measure to create, this way, when you select values in slicers, you will get your expected result.

Another way is to use visual level filters for each visual in the page.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , I doubt you can remove the page level filter. Try this

Sales Budget (Risk) Trend = calculate(sum(Backlog[Sales Budget]),all(Backlog))