Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

Count the number of purchase outlet

Hi BI Community Team,


To count the number of purchase outlet, I need to combine the column [Customer Code]&[Saleman Code] --- [Merge Cust with SR] and apply the measure below.


Measure 01 -- Dist_Count Active Store = DISTINCTCOUNT('Actual Sales'[Merge Cust with SR])


Measure 02 -- Total Active Store = CALCULATE([Dist_Count Active Store],'Actual Sales'[BillingType]="ZF2",'Actual Sales'[Price Type]="SALE")




Any suggestion of measure/metric that we can create only one and get the same result? 


Thanks and Regards,



Community Support
Community Support



Why not try calculating distinct count in the second measure directly?

Total Active Store =
    DISTINCTCOUNT ( 'Actual Sales'[Merge Cust with SR] ),
    'Actual Sales'[BillingType] = "ZF2",
    'Actual Sales'[Price Type] = "SALE"


Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Hi @v-jingzhang,


Thank you for your feedback.


Yes, currently I followed your measure. But we need to use the merge column name --- Merge Cust with SR that it's coming from  [Customer Code]&[Saleman Code] in power query.


It seem double job to merge and using it. Could we have another way/measure that can calculate and have two columns  [Customer Code]&[Saleman Code]?


Best Regards,

Helpful resources

Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.