Forum Discussion

jnn4282's avatar
jnn4282
Icon for Helper II rankHelper II
4 years ago
Solved

Filter the total count of Withdraw Numbers

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  ...

Need Help
  • MattAllington's avatar
    MattAllington
    4 years ago

    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]))

2 Replies

  • MattAllington's avatar
    MattAllington
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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's avatar
      jnn4282
      Icon for Helper II rankHelper II
      4 years ago

      Thank you dear MattAllington for your quick response.

      It helped me a lot