topic How to calculate default clients with a measure? in DAX Commands and Tips

How to calculate default clients with a measure?

Anonymous — Fri, 28 May 2021 14:43:32 GMT

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 — Fri, 28 May 2021 14:54:36 GMT

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 — Fri, 28 May 2021 16:10:14 GMT

Simple and direct, thanks a lot bro!