Forum Discussion

icdns's avatar
icdns
Icon for Post Patron rankPost Patron
3 years ago

Value not affected by report level filter

Hi, 

 

I would like to request for your help. I have a measure that displays the maximum date available in my dashboard (measure = Latest Date = MAX(Table[Date])). However, whenever I choose a filter on the right side, the value changes. Is it possible that the value will not be affected? I do not have filter slicers on the dashboard. I only have the report level filters. 

 

Thanks!

 

 

 

Need Help

1 Reply

  • johncolley's avatar
    johncolley
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hi icdns ,

     

    If you update your measure to the following it will ignore the page level filter:

    Measure = CALCULATE(MAX(Table[Date]), ALL (Table[Year Month]))

     

    If this answer solves your problem please mark it as a solution!