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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.