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

Hi StephenGW !

 

Please try using ALL() function to remove the filter cotext from [Audit Month] & [Audit Year] columns.

 

Fail Date = CALCULATE(MIN('Data'[Audit Date]), FILTER(ALL(Data, 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 

     

    Thanks but that makes the visual not display. The details say "The rport measure 'Data'[Fail Date] has a syntax or semantic error at line 1, position 53, reported by Analysis Services: 'Multiple table arguments are not allowed in the ALL function. Here is a screenshot of my filters and the table.

     

    I want the Location and Department slicers to apply to the measure but not the year or month. Only thing in the table is 'Data'[Area] and the measure.

     

    Thanks for the quick reply.

     

    StephenGW

    • AlexisOlson's avatar
      AlexisOlson
      Icon for Super User rankSuper User
      5 years ago

      ALL can take a table or columns but not both. Try removing the first argument in ALL:

       

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

       

      • 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