KonekteEnskri

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

poze a month ago249 gadefr

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 ?

🤖 Dyagnostik IA

Se IA ki fè l. Se pa yon repons — kominote a anba a konfime oswa korije l. Toujou verifye anvan ou fye l.

power-bidata-engineering
poze a month ago

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

     — jamesetienne 5 days ago

1 Repons

7
✓
✓ Repons yo aksepte

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.

Konekte pou di lòt moun si li te mache.

answered a month ago

Sign in and verify your email to post an answer.