Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have the following Table
Row | Customer # | Type Contact | Name | Comments |
1 | 1 | ACCT | Joe | Is ACCT |
2 | 2 | ACCT | Ted | Is ACCT |
3 | 2 | PURCH | Maria | Not ACCT and ACCT Exist for this Customer in other row |
4 | 3 | PURCH | Edy | Not 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!
Solved! Go to Solution.
Thank you very much! Just switched "Y" and "N". Nice solution creating a calculated column.
Hi Calculated column maybe.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
10 | |
6 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |