Data Last Year not shown when using a filter for Locations?

[Davidglol123]

Hi Power BI Forum,

I have used tremendous time on figuring out how to solve this issue. I have a Date Dim and a fact table, where I related the fact dates into date Dim. Therefore, I can filter using my date dim. I'm interresting further, to use my Location Dim, so sort out what location I wanna show based on my fact table. 

The following DAX is used : 

CO2_Green_KPI= CALCULATE([CO2_Per_Kg],DATEADD('Dato Dimension'[Date], -1, YEAR))

(Additonally, I also used sameperiodelastyear and tried to add ALL(Date) as other users have mentioned.

The following Picture shown here is that it works, when I have no filter on location therfore "all"

But, when I choose what of the location I end up with the following result 

I'm Interrested in having the line aswell, when location is choosen.

I tried to revoke the problem, by dragging a table out and put my location and CO2_Green_KPI into it, and the following error was displayed :

 I mean, do understand the problem but it just doesn't make sense to me?

Any help will be appericated. 

Regards,
David.

[amitchandak]

@Davidglol123 , You can not have bi-directional relationship with the date table. It causes Time intelligence to fail. Make it single directional

Refer

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...

[Davidglol123]

Hi Amit,

right now I have my date table single to many into my fact table. Aint that correct?

thanks!

[v-jingzhang]

Hi @Davidglol123 

Did you use the [CO2_Green_KPI] measure for the line? Can you show the DAX for the measure [[CO2_Per_Kg]]? In addition, you need to use the Dim Location's location column in the slicer, and create a one-to-many relationship to the location in Fact table. 

Best Regards,
Community Support Team _ Jing