cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
a10703
Frequent Visitor

Filter two tables and show only fields with these conditions

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)
 

 

a10703_0-1648641227726.png

 

Some solution for this?

 

best regards

1 ACCEPTED SOLUTION

Hi @a10703 ,

 

That you can do by visual level filter.

Arul_0-1648642489274.png

 try this approach in table and card visual.

 

Thanks,

Arul

Arul

View solution in original post

4 REPLIES 4
a10703
Frequent Visitor

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
Super User
Super User

Hi @a10703 ,

 

Can you please explain your requirements in more detail?

 

Thanks,

Arul

Arul
a10703
Frequent Visitor

Hi,

 

This is my DB Table:

a10703_0-1648641720217.png

 

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 .

 

a10703_1-1648642048181.png

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

 

Hi @a10703 ,

 

That you can do by visual level filter.

Arul_0-1648642489274.png

 try this approach in table and card visual.

 

Thanks,

Arul

Arul

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.