Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Qotsa
Helper V
Helper V

ALLSELECTED not applied

Hi,

 

In the below measure the ALLSELECTED(Week[Week] part is not being applied. If I remove it the result stays the same.

 

Select = CALCULATE([New Carers in 2019],WEEKNUM(CarersList[StartDate],2 > ALLSELECTED(Week[Week])))
 
I have a slicer where I pick the Week Number which uses Week[Week]
 
Any ideas why this is.
 
1 ACCEPTED SOLUTION
Iamnvt
Continued Contributor
Continued Contributor

hi,

 

you can try this:

Select = CALCULATE([New Carers in 2019],Filter(ALLSELECTED(Week[Week]), Week[Week] < WEEKNUM(CarersList[StartDate],2)))

View solution in original post

1 REPLY 1
Iamnvt
Continued Contributor
Continued Contributor

hi,

 

you can try this:

Select = CALCULATE([New Carers in 2019],Filter(ALLSELECTED(Week[Week]), Week[Week] < WEEKNUM(CarersList[StartDate],2)))

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.