Forum Discussion
Measure returning count instead of value
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
4 Replies
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.
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 )
