Forum Discussion
DIVIDE DISTINCT COUNT WITH FILTER
Hi Sachet_716
Lidya Anonymous is correct here. You need to have all possible codes in the customer table.
Just in case if you still want to make this work. Do the following
Step 1 - Delete the relationship between Sales and Customer Tables
Step 2 - Add a following measure to the Customer table
Total Customer Country Wise = CALCULATE(DISTINCTCOUNT(CUSTOMER[CUSTOMER CODE]),ALLSELECTED(CUSTOMER[COUNTRY]))
Step 3 : Update your Coverage % formula to
Coverage% = DIVIDE (DISTINCTCOUNT('SALES DATA'[Customer Code]) ,[Total Customer Country Wise])
Step 4: Insert a slicer on Country from Customer Table and NOT the Sales Table
I am supposing it should then work!
Sending you 2 files to look over -
With Relationships and Corrected Data
Without Relationships and (As is Data)
Sachet_716,
Could you please re-check your data? I note that you create relationship between Cutsomer and sales data table using customer code field, but the customer code of Customer table doesn't contain all the possible customer codes in sales data table.
Regards,
Lydia
Hi Lydia,
Yes, not all customers are included in the customer data list because we are billing some customers whihc are outside the specified journey plan, thus, I am expecting that there will be >100% on the answers. Is it wrong?
Rgds, Sachet