Forum Discussion

RemiAnthonise's avatar
RemiAnthonise
Icon for Helper V rankHelper V
7 years ago

Can't create relationship between Fact and Dim

Hi guys, I've got the following problem: In my model I've got Fact and Dim tables. I have a desired situation, see below.     In my model, you can find these fields in the following tables: ...
Need Help
Show and Tell
Tips and Tricks
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi RemiAnthonise,

 

Because in your digram, table 'FactClient' and 'FactWijkCodeBuurt' doesn't have direct relationship with each other, they relationship between them is many to many. So once one row has been filtered in table 'FactClient', power bi doesn't know which row should be selected in table 'FactWijkCodeBuurt'. However, you can use aggregation(average or sum) value in your chart as below:

 

 

Regards,

Jimmy Tao