Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Measure To Ignore Page Filter

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...
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    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.