DAX formula

[ccubs2331]

I have a table of accounts were is have a column Placed Date and a column Payment Date. I added a column and used a 

List to Payment Days = DATEDIFF(Debtor[Placed Date], Debtor[Payment date],DAY). I get the correct number from this. Now I am trying to see how many accounts have List to Payment Days greater than 30. I added a column and used 

List to Payment Days 30 = IF(SUM('Debtor'[List to Payment Days]) > 30, 1, 0). It is giving my a 1 on every account. I need to know were I went wrong.

Thank you

[harshnathani · Accepted solution]

HI @ccubs2331 ,

REmove SUM

List to Payment Days 30 = IF(Debtor'[List to Payment Days] > 30, 1, 0)

https://www.youtube.com/watch?v=03E0f-RyRn4

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)