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
HashamNiaz's avatar
HashamNiaz
Icon for Solution Sage rankSolution Sage
5 years ago

Thanks AlexisOlson for correcting it.

 

StephenGW So it could be like this;

 

Fail Date = CALCULATE(MIN('Data'[Audit Date]), FILTER(ALL(Data[Audit Month], Data [Audit Year]), Data[Pass/Fail]="Fail"))

 

Regards,

Hasham

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

HashamNiaz  and AlexisOlson 

 

I think we are getting close but now it's not seeing the column Pass/Fail in the filter for Data[Pass/Fail]="Fail". In the formula box it underlines it in red and says Cannot find name 'Pass/Fail'. I tried deleting the column and renetering to see what it offered for column names and it did not have any Pass/Fail column. Why is this column now missing?

 

Edit: If this helps the data is coming from a spreadsheet in my OneDrive for Business

 

Thanks