List of not visited clients

[Mapia-75]

I need your help again. I have calculated the coverage (link below) but now I need a list of clients that have not been visited. I have a table with all the visits  (Interactions) and a table with the full list of clients (ClientClassification). I managed to calculate the "Last visit date" in a new table, but how would you recommend to go about showing a list of clients that do not have any visit yet?

Something like new table - list of clients (ClientClassification) and then a filter like, does not exist in (Interactions)?

My original question Solved: How to calculate coverage rate - Microsoft Fabric Community

[lbendlin · Accepted solution]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Mapia-75]

Sorry. Here you go. Below the list I want to see. and a sample in the link. I have the "last visited" months but I am missing the "Not visited" thanks

https://docs.google.com/spreadsheets/d/1aoXDtVYPk61axENDqGcxiWko00yn0n2Z/edit?usp=drivesdk&ouid=1082...

Category	ID	Name	Last meeting
Very High	B4625363	Mary	January
Potential	B4357620	Patricia	Not visited
Very High	B4354502	Jennifer	February
High	B4345849	Linda	Not visited
Very High	B3564272	Elizabeth	March
Potential	B3484904	Barbara	Not visited

[lbendlin · Accepted solution]

All you need to do is enable "Show items with no data".

[lbendlin · Accepted solution]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...