Forum Discussion

Dex98powerbi's avatar
Dex98powerbi
New Member
1 year ago
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 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