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
StephenGW's avatar
StephenGW
Icon for Helper II rankHelper II
5 years ago

HashamNiaz  and AlexisOlson 

 

This counts what I want but it includes the slicers.

 

Fail Date =
CALCULATE(COUNTROWS(Data),FILTER(Data,Data[Audit Date]>=MAXX(
FILTER(Data,Data[Pass/Fail]="Fail"),
CALCULATE(MIN('Data'[Audit Date]))
)+0),FILTER(Data,Data[Pass/Fail]="Pass"))
 
 
The goal is to count how many Passes are equal to or greater than the most recent Fail date. This does this but I need it to ignore the month and year slicers.
 
Hope someone can help.
Thanks.
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

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!

  • m3tr01d's avatar
    m3tr01d
    Icon for Continued Contributor rankContinued Contributor
    5 years ago

    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.