cancel
Showing results for 
Search instead for 
Did you mean: 

ALLEXCEPT and Date Slicer

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')
)

Status: New
Comments
Community Support

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]))

4.JPG5.JPG

 

 

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