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 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
Need Help
  • 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.

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

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

    Sales Budget (Risk) Trend = calculate(sum(Backlog[Sales Budget]),all(Backlog))
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi amitchandak 

     

    It's a pity... 

     

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

    • V-lianl-msft's avatar
      V-lianl-msft
      Community Support
      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.