Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Customer Distinct Count with Multiple Conditions

Hi Experts,

Need your help to calculate distinct count of my customers by "Customer code" where SalesQty sum of basepack code "6A43B3A48TV170301" & "6A43B3A48TV170303" is equal or greater than 8. Condition is none of the basepack code alone should be less than 1. 

Download the excel data:





Community Support
Community Support

Hi @mamunabdullah ,


Try this measure:


    FILTER (
        OR (
            [Basepack Code] = "6A43B3A48TV170301",
            [Basepack Code] = "6A43B3A48TV170303"


And put it in the filter pane of this table visual then set it show items which is equal or greater than 8




Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-chenwuz-msft, maybe I couldn't make you understand my requirement. I need to check how many customers have purchased more than or equal 8 units of combined basepack "6A43B3A48TV170301" & "6A43B3A48TV170303". But each of the basepack purchase must not be less than 1. 

Frequent Visitor

Hi @ERD, I saw you solved similar problem! Can you pls help me out with this one?


Hello @mamunabdullah ,

Don't know if you still need some help, but you can try this measure:


YourMeasure = 
VAR t_with_b_code =
        CustomerSales[Basepack Code] IN { "6A43B3A48TV170301", "6A43B3A48TV170303" }
VAR rows_amt = COUNTROWS ( t_with_b_code )
    SUMX ( FILTER ( t_with_b_code, rows_amt = 2 ), [SalesQty] )



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.

Check out my latest demo report in the data story gallery.

Stand with Ukraine!

Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine:
2) Come Back Alive foundation:

Thank you!

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors