ALLEXCEPT fixed calc by month

[arrrlette]

I am trying to use the ALLEXCEPT function with a date in a calendar table. Basically, i want to tell it to allow it to filter to the month of the dates selected in the filter.

I am trying to get the "fixed funded count" column to instead of summing the entire time i select in my date slicer, to show the total for each month. so the first and second columns should match, but they dont:

here is my formula:

Here is my calendar table:

Any thoughts?

[Dangar332]

Hi, @arrrlette 

make a new column for month in Calender table
and use it in allexcept

if still not working then provide data

[Dangar332 · Accepted solution]

Hi, @arrrlette 

try to add .month after date in allexcept
like 

CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[date].[Month]))

[arrrlette]

this worked actually, i just needed to add same with .year as well. Thank you so much!!

[arrrlette]

that did SOMETHING - it now pulls the sum of the counts for the entire data set time period.