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]))
Attached is the PBIX Data. Click Here
Go to Solution.
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?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Submit your creative T-shirt design ideas starting March 7 through March 21, 2023.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!