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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Arydperez
Frequent Visitor

Filter rows in a table with group condition

Hi,

I have the following Table

RowCustomer #Type Contact NameComments
11ACCTJoeIs ACCT
22ACCTTedIs ACCT
32PURCHMariaNot ACCT and ACCT Exist for this Customer in other row
43PURCHEdyNot ACCT but  ACCT Does NOT Exist for this Customer

 

There are only 2 option of Type Contact: ACCT or PURCH

I need to filter the rows with the following conditions:

1. If Customer Type Contact is only ACCT, the row needs to be included.

2. If for a Customer there are both type of Contacts, select only ACCT.

3. If Customer Type Contact is only PURCH, the row needs to be included.

 

In the example, Green Rows should be included and the Red Row should NOT be included in my data.

I was trying to get a calculated row or measure that give a binarial value include /not include but I couldn't find a right one.

 

Thank you vm for your help!

1 ACCEPTED SOLUTION
rfigtree
Resolver III
Resolver III

Hi Calculated column maybe.

 

rfigtree_0-1612079982905.png

 

View solution in original post

2 REPLIES 2
Arydperez
Frequent Visitor

Thank you very much! Just switched "Y" and "N". Nice solution creating a calculated column.

rfigtree
Resolver III
Resolver III

Hi Calculated column maybe.

 

rfigtree_0-1612079982905.png

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.