Forum Discussion
Matrix View based on Month
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
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
1 Reply
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