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,