DAX for Less than and greater than date

[Userpath77]

Hello All

Probably a simple fix, but I can't figure it out. I have a column of dates and I just need a measure that counts how many dates are:

60 days or less than today, but greater that 45 days from today. Here is what I have, just not sure how to include the 45 day piece.

=Calculate(countrows(Elig_List),filter(Elig_List,Elig_List[Prom_Elig_date]-Today()<=60))

Thanks for any help!

[Fowmy]

Try this measure please:

Count Days = 
var __today = TODAY()
var __result = 
    CALCULATE(
        COUNTROWS( Elig_List ),
        Elig_List[Prom_Elig_date] >= (__today + 45) && Elig_List[Prom_Elig_date] <=  (__today  + 60) 
    )
return
    __result

[Userpath77]

I modified my original to this and it worked perfect:

CALCULATE(countrows(Elig_List),filter(Elig_List,Elig_List[Prom_Elig_Date]-TODAY()<=60),filter(Elig_List,Elig_List[Prom_Elig_Date]-TODAY()>45))

[Userpath77]

Thanks Fowmy. I tried but that measure doesnt populate on the visual-----it breaks the pie chart visual I have to use and says "cant display visual."