Forum Discussion
CountIf as CountAX
Hi, I am using this to count the repetition of CustomerID for each row CALCULATE(COUNTROWS(Orders),ALLEXCEPT(Orders,Orders[CustomerID])) Is it possible without Calculate to count the occurences ...
Yes but you syntax is incorrect:
COUNTAX(ALLEXCEPT(Orders,Orders[CustomerID]),[CustomerID])
It's giving me the overall total count in each row.