Forum Discussion
Differences COUNTAX and COUNTROWS
You can also use countax function
CustWithChildren =
COUNTAX(
FILTER(Customer, Customer[Total Children] > 0),
Customer[Customer ID]
)
You need to filter table which is not contains total children is 0.If you find these solutions accurate and helpful, please accept them as the solution to the problem.
Hello ThomasSan,
Try these Dax
CustWithChildren =
CALCULATE(
COUNTROWS(Customer),
Customer[Total Children] > 0
)
CountaX : This function counts the number of rows in a table where an expression evaluates to a non-blank value.
Hi Ronak131290
thank you for your reply. I was more looking for someone to explain to me why COUNTAX did not work. As far as I see it, it should have worked as it is supposed to count the entries within the Customer table where the values within the column Total Children is larger than 0. Is that not meant with "where an expression evaluates to a non-blank value."?
You can also use countax function
CustWithChildren =
COUNTAX(
FILTER(Customer, Customer[Total Children] > 0),
Customer[Customer ID]
)
You need to filter table which is not contains total children is 0.If you find these solutions accurate and helpful, please accept them as the solution to the problem.
