Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
a10703
Helper I
Helper I

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


View solution in original post

4 REPLIES 4
a10703
Helper I
Helper I

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.