Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DATESBETWEEN function applied to a measure

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
ALLSELECTED
datesbetween
hasonevalue

2 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    5 years ago

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

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

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