Hello,
I have 2 tables, one with leads (people that registered on my landing page), and the other with tasks (calls or emails my salespeople perform) to that leads.
I need a visual that shows me which leads did NOT have tasks performed on that day. Ex.: A Column chart, with the task date on X axis, with one bar for each day, and on the Y axis, all the leads that did NOT have a task done that day. And a table view (or matrix) the same way, giving a list of them.
Data Example:
D_Leads
| Lead ID | Lead Name |
| 001 | Jhon |
| 002 | Mary |
| 003 | Peter |
F_Tasks
| Taks_ID | Lead_ID | Task_Type | Done_at |
| 5001 | 001 | call | 01/01/2023 |
| 5002 | 002 | email | 01/01/2023 |
| 5003 | 001 | call | 01/02/2023 |
| 5004 | 002 | email | (blank) |
| 5005 | 003 | call | 01/01/2023 |
("Done_at" = blank, which means the task is planned, but not done yet)
Expected outcomes:
Any visual (preferably a column chart and a table/matrix) that shows the following info:
01/01/2023 = 0 or (blank) (all leads have a task this day)
01/02/2023 = 2 (that's the count of leads 002 and 003, because they have no task done this day)
01/03/2023 = 3 (because I've 3 leads and none of them had a task this day)
Idk if this can be done only with dax, or with filters directly on the visual, or even calculated columns or calculated tables.
Any help is welcome,
Ty in advance
