We are trying to figure out if a customer has signed up for a service by determing if they have a certain charge on a pending invoice.
Product A = 1, 2, 3
Product B = 4, 5 6
Product A Category = Opening
Product B Category = Closing
Customers can have any combination of the above mentioned products and I need filters with a customer count for the following measurements.
Opened but didn't close (ONLY PRODUCT A BUT NOT PRODUCT B)
Opened AND Closed (PRODUCT A AND PRODUCT B - ANY COMBINATION)
Closed but didn't Open (PRODUCT B BUT NOT PRODUCT A)
Each customer has a customer ID as the unique idenftifier.
I have tried a few ways but I can't get the 2nd one to work (opened and closed)
= calculate ( distinctcount (customer id), filter ( category = "Opened > Opened - General" || " Closed > Closed - General")
I'm really lost how to make this work. Any help would be apprciated.
Hi @QuantusPools ,
You need to provide the corresponding information according to the requirements in the following blog, I will answer you as soon as possible.
How to Get Your Question Answered Quickly - Microsoft Power BI Community
Here's some sample data
can you share the data in text form how it would look in a table?
Proud to be a Super User!
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.