Count of Duplicate Values (Count) of each Order in Power BI

[gauravnarchal]

Hello - I need help counting the same order no of each order serial. Below is the DAX I created but it is not giving me the count result of each order serial.

Count = CALCULATE(count(Table1[Order No]),ALLEXCEPT(Table1,Table1[Order No]))

Thanks

Attached is the PBIX Data. Click Here

[v-xinruzhu-msft · Accepted solution]

Hi @gauravnarchal 

 I make  a change on your code:

Count Order No = COUNTAX(FILTER(Table1,Table1[Order No]=EARLIER(Table1[Order No])&&Table1[ID]=EARLIER(Table1[ID])),[Order No])

Is  this the output you want?

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