Forum Discussion

Frequent Visitor

5 years ago

Solved

Filtrer une table sur relation inactive

Bonjour à tous, N'étant pas un expert PowerBi, j'espère que j'arriverai à être clair, je m'excuse par avance des "défauts" de language 🙂 Comme affiché sur la capture d'écra, j'ai 3 tables Utili...

Need Help

Tutorial Requests

Anonymous
5 years ago
Hi FranckP ,

Is there anything else need help about this thread? What's your expected result? Please review the content in the following links, hope they can help you.

Using RELATED function in DAX with USERELATIONSHIP

Concatenatex Lookupvalue multiple values

THERE’S ALWAYS AN INSIGHT WITH POWER BI: CONCATENATEX

Best Regards

amitchandak

Super User

5 years ago

FranckP , You have to create a measure with userelation and plot it with ID Vendeur OR ID Assistant based on what you join. You will get a list.

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

aj1973

Community Champion

5 years ago

FranckP

Vous pouvez aussi ajouter une autre table a votre model qui englobe les tables Commandes et Devis et la joindre a la table Utilisateurs. Mais cette méthode est au depend de la performance surtout si les tables sont suffisament grande.

Forum Discussion

Filtrer une table sur relation inactive

Related content

Multiple Dates with Inactive Relation

Filtercontext with date relation

Filter Related Table using inactive relationship

Filtrer in one line

Returning value from inactive related table