Forum Discussion
Calculate countax vs counta
I need your clarification I've table and I need to count all contents include numbers and text on specific column with specific condition
When use calculate(countax(Roster[today shift]), Age < 34) it gives me wrong result while calculate(counta(Roster[today shift], Age < 34) give right one what's the difference between them in this case?
I think I still don't understand filter concept in dax
Hi, MLinux
According to your description, Here is why using calculate(countax(Roster[today shift])), Age < 34) gives different results,
Assuming that the calculation context is the same for both measures
1.calculate(counta(Roster[today shift], Age < 34)) counts the number of rows with non-null values in the today shift column where the age column is less than 34 in the current calculation context.
- calculate(countax(Roster[today shift])), Age < 34) counts the number of non-blank rows in the Age < 34 column iterated over Roster[today shift] in the current calculation context.
Related Links:
Context in DAX Formulas - Microsoft Support
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
4 Replies
Hi, MLinux
According to your description, Here is why using calculate(countax(Roster[today shift])), Age < 34) gives different results,
Assuming that the calculation context is the same for both measures
1.calculate(counta(Roster[today shift], Age < 34)) counts the number of rows with non-null values in the today shift column where the age column is less than 34 in the current calculation context.
- calculate(countax(Roster[today shift])), Age < 34) counts the number of non-blank rows in the Age < 34 column iterated over Roster[today shift] in the current calculation context.
Related Links:
Context in DAX Formulas - Microsoft Support
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
I think may because we've misunderstanding for filter and x-function behaviour
Thx for your help
what I notice that when use iterative x function within filter function such as calculate it will ignore the filter if it happen in same table so in this case normal function like counta is right choice for my case
