Filter the total count of Withdraw Numbers

[jnn4282]

https://we.tl/t-mn5deO0fvy

Hi, friends,

I need your help finding a solution to my issue.

My excel data contains customer ID (unique) and is categorized with registration date, use date, withdrawal date, and rank.

I can count the total number of customers by distinct count. But I can't get the total number of customers who withdraws their

membership.

LeavingCustomer = CALCULATE(DISTINCTCOUNT(Table[CustomerID]),Table[WithdrawDate]) throughs an error.

Can someone help me Please  ...

[MattAllington · Accepted solution]

The filter clause (second parameter) in CALCULATE either needs to be a true/false statement (ie column= value) or a table function. Change this last parameter to NOT(ISBLANK(Table[WithdrawDate]))

[jnn4282]

Thank you dear MattAllington for your quick response.

It helped me a lot