List of contacts without records in related table

[apenaranda]

How could I get the list of contacts that have not been visited?
Scheme, contacts table related to interactions table.
The interactions table are records with the contact code and interaction code, in this case I need to check which contacts do not have any record with interaction code = SEG_CLI
The result must be the list of all contacts without SEG_CLI

[apenaranda]

customer table

cliente id

cliente1

cliente2

cliente3

interaccion table

id interaccion	id cliente	interaccion	date
1	cliente1	visita	01/01/2024
2	cliente1	visita	01/02/2024
3	cliente2	visita	01/01/2024
4	cliente2	instalacion	02/02/2024

The two tables are related.
What I want to get is a list of clients who have not made any visits. The visits are registered in the interaction table, as long as there is only one visit it is fine, the issue is that there are none. The easiest thing would be to see the interaction table directly and get the list but you have to keep in mind that not all clients have records, if they do not have records it means that they have not visited either, it should also be in the list of clients without a visit.

[Syndicate_Admin · Accepted solution]

Utilice "Mostrar elementos sin datos"

[Syndicate_Admin]

Para informar sobre cosas que no están allí, debe usar tablas desconectadas y/o combinaciones cruzadas

Proporcione datos de muestra que cubran su problema o pregunta por completo, en un formato utilizable (no como una captura de pantalla).

No incluya información confidencial ni nada que no esté relacionado con el problema o la pregunta.

Si no está seguro de cómo cargar datos, consulte https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Muestre el resultado esperado en función de los datos de muestra que proporcionó.

¿Quieres respuestas más rápidas? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...