Matrix View based on Month

[Anonymous]

Hi ,

i have Customer Master List in Table 1 and Customer Visit date wise in Table 2.

I need to calculate

1. No of visit met customer

2. Balance Visit

3. Missed Customer List and count

4. Reach (Total No.of Customer Met > 0 / Total No.of Customer ) based on Month or QTR in Slicer

[amitchandak · Accepted solution]

@Anonymous , Create common customer and Date table (with Qtr, Qtr Year etc) and then

1. No of visit met customer = count(Visits[Customer ID])

2. Balance Visit = Sum(Target[Quartely Target]) -  count(Visits[Customer ID]) 

3. Missed Customer List and count = Countx(Values(Customer[Customer ID]) , if(isblank([No of visit met customer]), [Customer ID] , blank() ) )  //Plot with customer dim

4. Reach (Total No.of Customer Met > 0 / Total No.of Customer ) based on Month or QTR in Slicer  = Divide(count(Visits[Customer ID]) , count(Customer[Customer ID]) )

When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw

When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda