Filter two tables and show only fields with these conditions

[a10703]

Hi guys,

I need to filter two tables

First Table : Only show the rows that meet the conditions (  "Delivered" that "QUEUE" > 30 seconds )

Second Table: Only show the rows that meet the conditions (  "Abandoned" that "QUEUE" > 30 seconds )

I create two measures for the 2 tables but doesn't work 😕

SHOW_ABANDONED_>30S = FILTER('TABLE_C', 'TABLE_C'[OUTCOME]="Delivered" && 'TABLE_C'[QUEUE] >30)

SHOW_ANSWERED_>30S_TABLE = FILTER('TABLE_C', TABLE_C[OUTCOME]="Delivered" && TABLE_C[QUEUE] >30)

My PBIX FILE: https://wetransfer.com/downloads/3dcdb842dbc2c471415214a8c779828420220330115516/6e9aa3

Some solution for this?

best regards

[a10703]

Thanks for help .

In my visual filter i create the condition selected for each table in OUTCOME selected Delivered and Abandoned filter and in QUEUE selection equal or higher than 30 . thanks 🙂

[Arul]

Hi @a10703 ,

Can you please explain your requirements in more detail?

Thanks,

Arul

[a10703]

Hi,

This is my DB Table:

I want to create in my PowerBi canvas two tables 

One table for all "Delivered" in my "OUTCOME" column if the value of "QUEUE"  >30 .

and Other table for all "Abandoned" in my "OUTCOME" column if the valued of QUEUE >30 .

Check the ANSWERED value : 7 , but in asnwered >30s table show me all the values and i want in these table only show me the 7 rows with these condition, understand?

MY PBIX FILE: https://wetransfer.com/downloads/3dcdb842dbc2c471415214a8c779828420220330115516/6e9aa3

Thanks for help

[Arul · Accepted solution]

Hi @a10703 ,

That you can do by visual level filter.

 try this approach in table and card visual.

Thanks,

Arul