DAX SUM of Measure HELP

[mcornfield]

I am trying to calculate Sum of Closed Accounts by Month-year.

I have a column of Dates for the last invoice date for all our customers.

I Created 2 Measures

9. Lastnonblank = CALCULATE(MAX(Dates[Date]),LASTNONBLANK(Dates[Date],[Invoice Count]))

Days from Last Invoice= VALUE(Today()-[9. Lastnonblank])

Now I need to get a SUM by Month-Year

I keep getting TOTAL for some reason HELP

[v-yetao1-msft]

Hi @mcornfield 

Has your problem been solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regard

Community Support Team _ Ailsa Tao

[v-yetao1-msft]

Hi @mcornfield 

Please try this formula ,count the number of [IF TEST2] group by month .

IF TEST3= CALCULATE(SUM(IF TEST2),FILTER(ALLEXCEPT(TABLE,TABLE(MONTH))))

Best Regard

Community Support Team _ Ailsa Tao

[amitchandak]

@mcornfield , Not very clear what the ask is, but data for the last date of the month

CALCULATE(Sumx(Values(Dates[Month Year]),LASTNONBLANK(Dates[Date],[Invoice Count])) )

[mcornfield]

Hello, THank you for your reply. I might have gotten myself in a Worm Hole.

The question I am trying to answer is "BY Month-Year How Many Accounts have Closed?"

We say if they haven't had an invoice in 90 days they are counted as closed.

So i have last Invoice data by Customer. Then i subtract that from today. If its over 90 days then i want to count it and look at it by month-year. 

But my formula seems to show the total and doesn't sum by month-year