How can i create a measure to count the number of orders a customer has done

[ligalbert]

I want to create a measure that tells me which number of order the customer currently has. for instance for customer 599-9175 he has two orders the new measure would tell me 1 for his first order and 2 for the second order. Please see the picture for visual understanding, I will be using powerbi to create such measure. thank you

 

[Anonymous]

Hi @ligalbert 

You can refer to the following measure

Measure = CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[Customer]),'Table'[Date]<=SELECTEDVALUE('Table'[Date]))

Best Regards!

Yolo Zhu

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

[DOLEARY85 · Accepted solution]

Hi, 

you're likely going to want to create a running total grouped on the ID field:

try something like this:

Running Total (m) =

    CALCULATE (

        SUM  ('Table (3)'[Order Count]),

        FILTER (

        ALLEXCEPT ('Table (3)','Table (3)'[ID]),

        'Table (3)'[Order Date] <= MAX ('Table (3)'[Order Date])))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍