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?

  • LaurensM03's avatar
    LaurensM03
    New Member
    2 years ago

    Hi, I created a measure to use as a filter in the filter pane applying it to a table visual.