Measure returning count instead of value

[Aydeedglz]

Hi I am creating a mesaure to see my total sales by specific month, but the result is a COUNT and I want the SUM, but I can't see the data that way. I have treid in measure and quick measure and is not working.

I have my data en decimal number and date, any ideas how to change the result to a sum instead of a count? thanks 

[Anonymous]

can you provide some sample data with your formula?

To my understanding CALCULATE(SUM()) and SUMX() are essentially the same thing. In your Calculate(SUM()) statement you're not passing a filter condition. From DAX: Calculate(<Expression>, <Filter1>, <Filter2>, etc.)

I would expect the formula to look more like this (assuming your [Two Months Back] is a binary column):

Sum of Past Due_M total for Two Months Back = 
CALCULATE(
     SUM('LND_SPF_PDReport'[Past Due_M]),
        'LND_SPF_PDReport'[Two Months Back] = 1
)

CALCULATE function (DAX) - DAX | Microsoft Learn

[Aydeedglz]

Hi,

The two months back is the month, example if today is December 2022 is going to be October 2022

I have tried your formula, but I still have a Blank result in my measure 

[nick_potts]

Just making sure, Past Due_M is a number type right? What is the filter expression? It looks like you need to add some boolean expression there. If Past Due_M is an integer then SUM() should be working.

[Aydeedglz]

Yes, PAST DUE is number and decimal, but I still have a count as a result