Forum Discussion

Davidglol123's avatar
Davidglol123
New Member
4 years ago

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

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.

3 Replies