How to calculate default clients with a measure?

[Anonymous]

Hi,

I have a Sales Table that shows the sale pay date and the date that the client in fact payed for the product, called "Sales Off". 

If today is greater than the pay date and the Sales Off cell is empty, it means that the client has default.

I'd like to build a measure that could show the amount default per client, how could I do that?

[Fowmy · Accepted solution]

@Anonymous 

Your measure could be something like: 

Measure = 

CALCULATE(
    sum('Sales Table'[Amunt]),
    FILTER(
        'Sales Table',
        'Sales Table'[sales Off] = BLANK() &&
        'Sales Table'[pay date] <  TODAY() 
    )
)

[Anonymous]

Simple and direct, thanks a lot bro!