hello,
I would like to ask for help.
I calculated accomulated week (Week Sales - see below). This measure I use for grapth.
For total country it works - I see accomulated data (picture 1). But when I using filters by regions it dosent't work - becuase data for 2a or 3 (please see attached file) dosen't exist (picture 2).
Week Sales =
I will be glad for your help.
Hi @Ewa_28 - Slight adjustment of your measure to handle , when filtering by regions where some weeks have no data, causing gaps in your accumulated week sales calculation.
Week Sales =
VAR _select_week = MAX('calendar'[week])
VAR _select_kwartal = MAX('calendar'[q])
VAR _select_year = MAX('calendar'[year])
VAR _cur_week = MAX('Sales'[week])
VAR _cur_kwartal = MAX('Sales'[q])
VAR _cur_year = MAX('Sales'[year])
VAR AllWeeksInFilter =
CALCULATETABLE(
VALUES('calendar'[week]),
ALLSELECTED('Sales')
)
VAR Result =
IF(
_cur_year = _select_year
&& _cur_kwartal = _select_kwartal
&& _cur_week <= _select_week,
CALCULATE(
SUM('Sales'[Sales]),
'Sales'[week] IN AllWeeksInFilter,
'Sales'[q] = _cur_kwartal,
'Sales'[year] = _cur_year
)
)
RETURN
Result
Hope this helps.
Proud to be a Super User! |  |
hi,
I implemented your solution but unfortunatelly it dosen't work 😞
this picture shows data for all regions, it isn't accumulated data
and
filter by one of regions: this data is not accumulated and I lost week where is no data
please help me!
Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
