Hello,
I have a below table:
| Transaction ID | Customer ID | Customer Type | Created On | Alerted? |
| 1 | 1 | CUSTOMER | 01.01.2022 | Not Alerted |
| 2 | 1 | CUSTOMER | 01.02.2022 | Not Alerted |
| 3 | 1 | VENDOR | 01.03.2022 | Alerted |
| 4 | 1 | BANK | 01.04.2022 | Not Alerted |
| 5 | 1 | VENDOR | 01.05.2022 | Alerted |
| 6 | 2 | VENDOR | 01.01.2022 | Not Alerted |
| 7 | 2 | VENDOR | 01.02.2022 | Not Alerted |
| 8 | 2 | BANK | 01.03.2022 | Not Alerted |
| 9 | 2 | BANK | 01.04.2022 | Not Alerted |
| 10 | 2 | BANK | 01.05.2022 | Alerted |
| 11 | 2 | BANK | 01.06.2022 | Not Alerted |
| 12 | 2 | BANK | 01.07.2022 | Not Alerted |
| 13 | 2 | CUSTOMER | 01.08.2022 | Not Alerted |
| 14 | 2 | CUSTOMER | 01.09.2022 | Not Alerted |
| 15 | 2 | CUSTOMER | 01.10.2022 | Not Alerted |
| 16 | 2 | CUSTOMER | 01.11.2022 | Not Alerted |
| 17 | 2 | CUSTOMER | 01.12.2022 | Not Alerted |
| 18 | 3 | CUSTOMER | 01.01.2022 | Not Alerted |
| 19 | 3 | CUSTOMER | 01.02.2022 | Not Alerted |
| 20 | 3 | CUSTOMER | 01.03.2022 | Not Alerted |
| 21 | 3 | CUSTOMER | 01.04.2022 | Not Alerted |
| 22 | 3 | VENDOR | 01.05.2022 | Not Alerted |
| 23 | 3 | CUSTOMER | 01.01.2022 | Not Alerted |
| 24 | 3 | CUSTOMER | 01.02.2022 | Not Alerted |
| 25 | 3 | CUSTOMER | 01.03.2022 | Not Alerted |
| 26 | 3 | CUSTOMER | 01.04.2022 | Not Alerted |
| 27 | 3 | BANK | 01.05.2022 | Alerted |
| 28 | 3 | VENDOR | 01.06.2022 | Not Alerted |
| 29 | 3 | VENDOR | 01.07.2022 | Not Alerted |
| 30 | 3 | VENDOR | 01.08.2022 | Not Alerted |
| 31 | 3 | VENDOR | 01.09.2022 | Not Alerted |
| 32 | 3 | VENDOR | 01.10.2022 | Not Alerted |
| 33 | 3 | VENDOR | 01.11.2022 | Not Alerted |
| 34 | 3 | VENDOR | 01.12.2022 | Not Alerted |
It contains unique [Transaction ID], but the Business Partner ([Customer ID]) can appear multiple times - also each Business Partner can have many roles: customer, vendor or bank.
Each Transaction is validated and can receive an Alert (column: [Alerted?]).
Creating visual with transactions status (Alerted vs. Not Alerted) was easy, but I can't figure out how to show on pie chart business partners with their status. Each Business Partner should be able to be filtered by [Customer Type] and [Created On] date.
Without the specific measure the visual shows duplicated distinct count (as each Business Partner is Alerted for some transactions, but also has status 'Not Alerted' for other transactions.
Do you know what measure could solve this issue? If the Business Partner for selected slicers would have 'Alerted' status - it should only appear as 'Alerted' and not as 'Not Alerted'. Currently the visual shows duplicates (which is a standard behavior for distinct count with applied legend.
I'd be very grateful if you'll help me with solving that.
Cheers,
Anna
Helpful resources
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.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
