Forum Discussion

AliceA's avatar
AliceA
Regular Visitor
3 years ago
Solved

New column for total based on another table

Hi all, I think this should be obvious, but I can't figure out. Your help would be appreciated.   So, I have this table called Customers. One line per Customer.   I have a second table called Pu...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi AliceA ,

     

    I tried to reproduce it.

    And you can create a calculated column in Customers table to count the number of purchases.

    Count = CALCULATE(COUNT(Purchases[Purchase ID]),FILTER('Purchases',[Customer ID]=EARLIER(Customers[Customer ID])))

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

You do not need to create a calculated column formula - a measure should suffice.  Share some data to work with and show the expected result.