Forum Discussion

StephenGW's avatar
StephenGW
Icon for Helper II rankHelper II
5 years ago
Solved

Ignore Slicer in Measure

Hello,   I read a few similar threads but couldn't find one that would work with my measure. I made this measure using Quick Measure to find the most recent date where a column equals "Fail".    ...
Need Help
m3tr01d's avatar
m3tr01d
Icon for Continued Contributor rankContinued Contributor
5 years ago

You'll need to use either 

ALL( Data[Audit Month], Data [Audit Year]), Data[Pass/Fail]="Fail")

or

ALL( Data[Audit Month], Data [Audit Year]), Data[Audit Date] )

 if you want to remove the filter on Month and Year slicer and also filter Audit_Date or Pass/Fail column