Forum Discussion

iamprajot's avatar
iamprajot
Responsive Resident
8 years ago

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 ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Yes but you syntax is incorrect:

 

COUNTAX(ALLEXCEPT(Orders,Orders[CustomerID]),[CustomerID])
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

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's avatar
    iamprajot
    Responsive Resident
    8 years ago

    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's avatar
      iamprajot
      Responsive Resident
      8 years ago

      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.