CountIf as CountAX

[iamprajot]

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]))

[Greg_Deckler]

Yes but you syntax is incorrect:

COUNTAX(ALLEXCEPT(Orders,Orders[CustomerID]),[CustomerID])

[iamprajot]

@Greg_Deckler

It's giving me the overall total count in each row.

[Zubair_Muhammad]

@iamprajot

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]
)

[iamprajot]

@Zubair_Muhammad

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.

[iamprajot]

Hi, @Greg_Deckler/@Zubair_Muhammad

You seems to be having a good catch on DAX and how to use it to get the desired result.
I have 1 question for you, how can I be better at DAX and get the complete understanding of utilizing the DAX functions to get the desired result.

I mean what you would suggest based on your experience that helped.

Books do not cover functions deeply as much as they should so what do you suggest that really helps.

Any specific Book/PDF/This Community/Any other source.