comment filtrer plusieurs éléments sur 2 bases

[Gwen]

Bonjour,

J’ai des personnes qui ont plusieurs activités (IA = Seller et INTERVENANT = Consultant)

la base r_cdr(2) pour les donnees quand INTERVENANT

la base r_cdr pour les données IA

les 1eres réponses m’ont permis de faire une table de jointure

Manager = distinct(UNION(DISTINCT(SELECTCOLUMNS('r_cdr',"intervenant ,..

J’ai aussi besoin de filtrer l’année « ANNEE PROD » même fonctionnement dans les 2 tables de données

Merci d’avance

[v-shex-msft]

Hi @Gwen,

I'd like to suggest you take a look at the following link to use star schema to rebuild your table relationships. (you can create some dimension table with fact table uniuqe key and use them as the bridge to link tables)

Understand star schema and the importance for Power BI - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@Gwen , why both middle/master table has many to many join.

If needed you can create a combinevalues  (function) for manage and year on both facts and dimension table and try to create 1-M join single direction.

Also why the year has M-M , it should have distinct years.

Can you share a sample pbix after removing sensitive data.

[Gwen]

Hello Could you please tell me how I can share the base?