Forum Discussion
Total Count of Inactive Customers
Hello all,
I would like some assistance on how I want to display the total count for my 'Inactive Cust'. This column is based on whether they make a transaction based on certain period. My goal is to show the total count when (Inactive Cust =1 / Activation Status = Inactive). The last 3 columns I calculated as a 'New measure' from the main table. (public swipey_core_transaction) I have referred some references, but still doesn't work for me.
I would really appreciate if anyone can help me with this. Tq in advace.
Hi,
Does this measure work?
=countrows(filter(values(public swipey_core_transaction[card_id]),[Inactive cust]=1))
3 Replies
Hi,
Does this measure work?
=countrows(filter(values(public swipey_core_transaction[card_id]),[Inactive cust]=1))
You are welcome.