Forum Discussion
Calculate countax vs counta
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
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 Team
If 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
This both makes sense and makes my head hurt
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
