Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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.
 
Need Help
  • Iamnvt's avatar
    Iamnvt
    7 years ago

    hi,

     

    you can try this:

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

1 Reply

  • Iamnvt's avatar
    Iamnvt
    Continued Contributor
    7 years ago

    hi,

     

    you can try this:

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