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 of a String in a column and get the result in Column
Something like
COUNTAX(Orders,ALLEXCEPT(Orders,Orders[CustomerID]))
5 Replies
Yes but you syntax is incorrect:
COUNTAX(ALLEXCEPT(Orders,Orders[CustomerID]),[CustomerID])
I think using ALLEXCEPT as table expression in X - ITERATORs typically yields circular dependency error
= COUNTAX ( FILTER ( Orders, Orders[Customer ID] = EARLIER ( Orders[Customer ID] ) ), [Customer ID] )It's working but I looking for something based on just COUNTAX and ALLEXCEPT and no use of Filtering or Earlier or any other function.
It's giving me the overall total count in each row.
