DATESBETWEEN function applied to a measure

[Anonymous]

Hi,

Is there a way to apply a datesbetween function to this measure?

%  Sum = IF(HASONEVALUE('Sort Table - Month Year'[Month Year]),[Measure 3],

SUMX(

ALLSELECTED('Sort Table - Month Year'),

[Measure 3]

))

I've tried this but it doesn't seem to be working:

% Attendance Sum 2018 = 

IF(HASONEVALUE('Sort Table - Month Year'[Month Year]),[Measure 3],

CALCULATE(SUMX(

ALLSELECTED('Sort Table - Month Year'),

[Measure 3]

),DATESBETWEEN('DimDate'[Dates],DATE(2018,1,1),DATE(2018,12,31))))

Thanks in advance for any help

[amitchandak]

@Anonymous , Try like

% Attendance Sum 2018 =
IF(HASONEVALUE('Sort Table - Month Year'[Month Year]),[Measure 3],
CALCULATE(SUMX(ALLSELECTED('Sort Table - Month Year'),[Measure 3]),filter(all('DimDate'),(DATESBETWEEN('DimDate'[Dates],DATE(2018,1,1),DATE(2018,12,31)))
) )

% Attendance Sum 2018 =
IF(HASONEVALUE('Sort Table - Month Year'[Month Year]),[Measure 3],
CALCULATE(SUMX(ALLSELECTED('Sort Table - Month Year'),[Measure 3]),DATESBETWEEN('DimDate'[Dates],DATE(2018,1,1),DATE(2018,12,31)))
)

[wdx223_Daniel]

the filter context bring in by CALCULATE might be overwrited by ALLSELECT