Forum Discussion

adam_macs's avatar
adam_macs
Helper I
4 years ago
Solved

Filter out rows

Hi, I’m trying to figure out how to filter our Trusts with a "Count of Mat Customers" = Blank but show the entire Trust and its Establishments if it has at least 1 "MAT Customer". So, from the examp...
Help Request
  • v-jianboli-msft's avatar
    v-jianboli-msft
    4 years ago

    Hi adam_macs ,

     

    Based on your description, I have created a simple sample:

     

    Then create a measure to help filter the data:

    Flag = IF(ISBLANK( CALCULATE(COUNT('Table'[MAT Coustomers]),FILTER(ALL('Table'),[Trust]=MAX('Table'[Trust])))),0,1)

    Apply it to the visual:

    Then filter the data:

    Final output:

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
4 years ago

Hi adam_macs ,

 

Based on your description, I have created a simple sample:

 

Then create a measure to help filter the data:

Flag = IF(ISBLANK( CALCULATE(COUNT('Table'[MAT Coustomers]),FILTER(ALL('Table'),[Trust]=MAX('Table'[Trust])))),0,1)

Apply it to the visual:

Then filter the data:

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.