Forum Discussion
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". ...
Thank you everyone for the help. I ended up going a different route that can be seen here.
Solved: Re: Count by criteria - Microsoft Power BI Community
StephenGW
Hi StephenGW ,
Try:
Fail Date = CALCULATE(MIN('Data'[Audit Date]), FILTER(ALL(Data), Data[Pass/Fail]="Fail"))No need to emphasis 2 fields after All,just choose all the table.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
This approach can yield really bad performance if the table has lot of million rows and lot of columns, Alberto Ferrari/Marco Russo always recommends using the minimum number of columns in an ALL Statement.