Forum Discussion

LaurensM03's avatar
LaurensM03
New Member
2 years ago

Filter a table based on measure with multiple OR's

Dear all,   I am trying to filter a table based on the measure pasted below. A row from the table 'sheet1' should be shown in the table if: the column 'parent link' contains the string as defined...
Need Help
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

but a measure cannot be a table, did you create a measure?

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

write like this and select 1

 

Filter missing requirements =
VAR MTMB = "ABN-1095"
VAR Filtermissing =
    FILTER('Sheet1',
        CONTAINSSTRING('Sheet1'[Parent Link], MTMB) &&
        'Sheet1'[CRA Intake Status] = "To Do" ||
        'Sheet1'[Eligible for Capitalisation] = "No" ||
        ISBLANK('Sheet1'[Eligible for Capitalisation]) ||
        'Sheet1'[Solution Intent status] = "Undefined" ||
        'Sheet1'[Solution Intent status] = "To Do"
        )

RETURN
if ( COUNTROWS(Filtermissing)>1,1,0)

 

 

  • thuoc115's avatar
    thuoc115
    Icon for Advocate I rankAdvocate I
    2 years ago

    Thank you

    • Ahmedx's avatar
      Ahmedx
      Icon for Super User rankSuper User
      2 years ago

      it was the right decision, if so then you will accept it as a decision?