Count the number of purchase outlet

[ADSL]

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,

[v-jingzhang]

Hi @ADSL 

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

Total Active Store =
CALCULATE (
    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.

[ADSL]

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,