Measures to returning correct value

Dex98powerbi — Tue, 01 Jul 2025 02:56:35 GMT

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 the week belongs to example date 31st December 2024 , week year is 2025 because it is week1 of 2025). The table consist date from 2019 to 2025

everything is working correctly including the custom column weekyear. Until if i place my measures with weekyear, it is not returning the correct thing. It starts showing year 2019 to 2025 even if I do not have any sales data from 2019 to 2023.

Below are my measures

total_sales_all_session =

CALCULATE(

SUM('sales'[sales_amount]),

'date'[week_year] IN {2025, 2024}

)

draws_all_session =

CALCULATE(

SUM('date'[is_draw_date_session]),

'date'[is_draw_date] = TRUE,

'date'[week_year] IN {2024, 2025}

)

total_normalise_sales_all =

[total_sales_all_session]/[draws_all_session]

if i am using year and week in the visuals, logically are correct, because it did not include year from 2019 to 2023. When i use week with the custom week year, it will start display values from 2019 to 2025.

I tried my custom column with the data directly from the sales table, it works fine. Just problem with my measures

Re: Measures to returning correct value

Jihwan_Kim — Tue, 01 Jul 2025 03:35:17 GMT

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

Re: Measures to returning correct value

Dex98powerbi — Tue, 01 Jul 2025 03:56:28 GMT

Thank you very much, after days of research, debugging, and your simple "Keep Filters" finally solved my headache.

topic Re: Measures to returning correct value in DAX Commands and Tips

Measures to returning correct value

Re: Measures to returning correct value

Re: Measures to returning correct value