Forum Discussion
Solved
Remove Variable filter context
Hi, I am calculating earned premium up till a specific date using the variable "LatestReportingDate". However, when using this variable, the filter context "YOA <= 2020" is kept. Earned =...
Hi MrMichael
The LatestReportingDate will return the last available date in in current filter context only if the year is 2020 or less. In the case of the year 2021 it will return blank. In this case the measure will also return blank as there is no blank date in your table.
You can FILTER ( ALL ( Table ), ..... in both measures but the best way to achieve what you need is the have a date table.
Thank you.
However, I find that using ALL on both measures, removes connections in my model which makes earned premium the same for all years.