display week base on week slicer

[Fiala]

Hellou, can you please somebody help me?

I have pivot table like this and slicer with week.

Week	value
1	10
2	20
3	30
4	40
5	50
6	60
7	70
8	80
9	90
10	100

If I select the tenth week, I want to see in the table only the values ​​up to the tenth week. If I select the fourth week, I only want to see the values ​​until the fourth week.

I create a measure like this: 

=Weekslicer = IF(HASONEVALUE('Calendar'[week]);VALUES('Calendar'[week]))

.. and measure: 

=var selectedweek= [Week slicer]

var currentweek=CALCULATE(max('Calendar'[week]);ALLEXCEPT('Calendar';'Calendar'[week]))

return

IF(currentweek<=selectedweek;sum(table;[vlaue]);BLANK())

Slicer still always filters only 1 selected week 😕

[Greg_Deckler · Accepted solution]

@Fiala This is pretty much the exact scenario for The Complex Selector: The Complex Selector - Microsoft Power BI Community