Sign up

Power BI: relations plusieurs-à-plusieurs, bonne pratique ?

asked 2 months ago309 viewsfr

2

J'ai deux tables de faits qui partagent une dimension. Power BI crée une relation plusieurs-à-plusieurs.

Est-ce que je devrais créer une table de pont (bridge table) ? Quel impact sur les performances des mesures DAX ?

AI diagnosis

AI-generated. Not an answer — the community below confirms or corrects it. Always verify before relying on it.

power-bidata-engineering
asked 2 months ago

  • Thanks, this helped. Did you also try clearing the cache?

     — jamesetienne 2 months ago

1 Answer

7
✓
✓ Accepted answer

Yes, use a bridge table. Create a distinct dimension with unique keys, relate both fact tables to it as many-to-one, and hide the raw many-to-many. DAX measures stay simple and USERELATIONSHIP becomes unnecessary.

Sign in to tell others whether this worked.

answered 2 months ago

Sign in and verify your email to post an answer.