ALLEXCEPT and Date Slicer

[syervin]

Hi,

The following formula Doesn't ignore date slicers on the first section of the formula when using ALLEXCEPT. Just want to know if there was a solution to this. 

a) Want to ignore all other filters except Projects Filter and RC Filter.

b) date slicer filter seems to be included

Amount2 =

//NOT WORKING
CALCULATE(
SUM('DatabaseData'[Amount]),
ALLEXCEPT(
'DatabaseData',
'DatabaseData'[Project],
'DatabaseData'[RC]
),
'DatabaseData'[Type]="Outstanding Revenue"
)
+

//WORKING
CALCULATE(
SUM('DatabaseData'[Amount]),
'DatabaseData'[Type]<>" Outstanding Revenue",
ALLSELECTED('DatabaseData')
)

[v-lili6-msft]

hi  @syervin 

for your case, all the fields are in the one table, it's better that do not use ALLEXCEPT in the measure.

you'd better add two dim table for 'DatabaseData'[Project] and 'DatabaseData'[RC].

for example:

Total Incrementos 2 = CALCULATE(sum('Table'[Total]),ALLEXCEPT('Table',Project[Project],'Date'[Date]))

I have done a demo, you could try it.

https://qiuyunus-my.sharepoint.com/:u:/g/personal/linli_qiuyunus_onmicrosoft_com/EZM-MF0achxOjtsdlWw...

Regards,

Lin