Forum Discussion
Solved
Measures to returning correct value
I have a sales table that consist [date,sales amount] There is sales date from 2024 and 2025 I have date table that consist [date, year, month, day, week, weekyear(custom column to show year does th...
Hi,
I am not sure if I understood your question correctly, but please try using KEEPFILTERS DAX function in the measures that you wrote.
KEEPFILTERS function (DAX) - DAX | Microsoft Learn
Jihwan_Kim
Super User
Super UserHi,
I am not sure if I understood your question correctly, but please try using KEEPFILTERS DAX function in the measures that you wrote.
KEEPFILTERS function (DAX) - DAX | Microsoft Learn
Thank you very much, after days of research, debugging, and your simple "Keep Filters" finally solved my headache.
