data model ambiguity

[Anonymous]

Hi,

For some time I am learning PowerBI and while my knowledge is increasing slowly, I still have issues with creating a new data model relationship 🙂

I have the following structure:

Calendar : Date Table

2021-2022 : Actuals 2021 - 2022

LE 2021 - 2022 : Latest Estimate 2021 - 2022

Mapping : Mapping per project

So the PowerBI visualization was working as I had only data for 2021. Now I added in my LE 2021-2022 data for 2022, but somehow I am not able to connect it with the Calendar table in order to filter per YEAR as it creates Ambiguity between Actuals 2021-2022 and Calendar Table. I understand that it creates ambiguity, but I am just not sure on how to solve it... 🙂

Any advice?

[amitchandak]

@Anonymous , There are two paths to reach from Year to Actuals 2021 - 2022

If mapping is fact it should not join with  Actuals 2021 - 2022

or have fact mapping and merged fact from mapping and Actuals 2021 - 2022

and they should not join with each other

[Anonymous]

@amitchandak thanks

I will have a look.

The problem is actually with the LE table. There I have LE per project for different years and I am not sure on how to connect that with my actuals table (should it be merged or via relationship...). It is perhaps difficult to advice if you do not have the full data, but any advice is welcome 🙂