DAX Filter not working as expected

Power BI Data Model
1

Hi,

I’m trying to improve my model by creating a lookup table with some calculations in. My 2 questions are:

  1. Why does my weight column have all the same value after I add the extra date filter?
  2. Do these lookup table calculations get updated when the data gets refreshed?

1
1.jpg1137×439 120 KB
2
2.jpg1440×437 124 KB

Many Thanks Nathan

2

Not sure why you believe you need to do this as this can be done much better as measures. Does this information really need to be in here in calculated columns? Can you do this as a DAX measure and will it work in with other calculations you are completing?

Regarding the calculation it’s due to the context of the calculation within your formula. It likely isn’t able to create the filter this way because the rest of the model isn’t setup for it to do so.

Yes, calculated tables get updated on refresh.

I’m just not sure this is required what you are doing here, I’m interested to understand why you think you need to do it?

Thanks
Sam

3

Thanks to the contributors of this post. Due to the length by which this post has been active, we are tagging it as Solved. For further questions related to this post, please make a new thread.