Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Distinct count active customer by month

Hi,   I have a 'transaction table' which have transaction date, amount transacted and account code, which will linked (relationship) to a 'account table' where I can see the client ID and account t...
Need Help
  • Floriankx's avatar
    Floriankx
    8 years ago

    So, there is a little trick.

     

    I created 2 measures:

    For Unique Account Code: 

    Active Customer:=CALCULATE([Measure];FILTER(Transactions;Transactions[Amount]>0))

     

    For Unique Client ID:

    Active Customer ID:=CALCULATE(COUNTROWS(VALUES(Customer[Client ID]));FILTER(Transactions;Transactions[Amount]>0))

     

     

    I hope this is what you are looking for.

     

    Best regards.

Floriankx's avatar
Floriankx
Solution Sage
8 years ago

So, there is a little trick.

 

I created 2 measures:

For Unique Account Code: 

Active Customer:=CALCULATE([Measure];FILTER(Transactions;Transactions[Amount]>0))

 

For Unique Client ID:

Active Customer ID:=CALCULATE(COUNTROWS(VALUES(Customer[Client ID]));FILTER(Transactions;Transactions[Amount]>0))

 

 

I hope this is what you are looking for.

 

Best regards.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Floriankx, thank you very much. Now the FILTER function better and also learn new function like Countrows. I will look into it further when have time.

 

Reallly appreciate your time and patience for teaching me.