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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
QuantusPools
Frequent Visitor

Filter Single Column

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. 

3 REPLIES 3
v-henryk-mstf
Community Support
Community Support

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


Best Regards,
Henry

 

QuantusPools
Frequent Visitor

Here's some sample data

 

Item CodeMember StatusCreated DateInvoice DateCategoriesCustomer ID
O-POOLInactive1/21/20215/8/2021Opening > Opening - General12283953
C-POOLInactive8/26/2021 Closing > Closing - General12283953
O-POOLActive3/8/20214/21/2021Opening > Opening - General12283971
C-POOLInactive8/30/2021 Closing > Closing - General12283979
O-POOLActive2/18/20215/4/2021Opening > Opening - General12283984
O-POOLSPAActive1/21/20214/30/2021Opening > Opening - General12283992
O-POOLActive3/12/20215/6/2021Opening > Opening - General12284008
C-POOLActive9/7/2021 Closing > Closing - General12284008
O-POOLActive3/2/20214/24/2021Opening > Opening - General12284017
C-POOLActive9/8/2021 Closing > Closing - General12284017
O-POOLInactive1/27/20214/12/2021Opening > Opening - General12284037
C-POOLSPAActive9/15/2021 Closing > Closing - General12284038
O-POOLInactive2/8/20215/21/2021Opening > Opening - General12284044
C-POOLInactive8/30/20219/14/2021Closing > Closing - General12284044
C-POOLActive8/28/2021 Closing > Closing - General12284048
O-POOLActive5/6/20215/8/2021Opening > Opening - General12284048
O-POOLSPAActive4/27/20214/30/2021Opening > Opening - General12284051
C-POOLSPAInactive8/25/2021 Closing > Closing - General12284058
O-POOLSPAActive5/18/20215/25/2021Opening > Opening - General12284065
O-POOLActive5/24/20215/15/2021Opening > Opening - General12284068
O-POOLInactive3/17/20215/3/2021Opening > Opening - General12284071
C-POOLInactive9/14/2021 Closing > Closing - General12284071
O-POOLSPAActive4/12/20215/7/2021Opening > Opening - General12284077
vanessafvg
Super User
Super User

can you share the data in text form how it would look in a table?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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