Forum Discussion
Solved
Countif with a column from a different dataset
Hello everyone, can you please support me with the following dilemma? I would like to have in a column the count of activities created by each user (not performed by each user, the difference is...
You should always provide some data when you ask people to write DAX against it.
COUNTROWS takes a table as an argument, thats' what the error is telling you.
Try this but I'm not sure it's what you are after, I'll need to see your data and you should provide an example of the result you expect
= CALCULATE(COUNTROWS('Coaching Tracker'), FILTER('Coaching Tracker', RELATED('Count of Activities'[Email]) = 'Coaching Tracker'[App User]))Regards
Phil
PhilipTreacy
Super User
Super User
You should always provide some data when you ask people to write DAX against it.
COUNTROWS takes a table as an argument, thats' what the error is telling you.
Try this but I'm not sure it's what you are after, I'll need to see your data and you should provide an example of the result you expect
= CALCULATE(COUNTROWS('Coaching Tracker'), FILTER('Coaching Tracker', RELATED('Count of Activities'[Email]) = 'Coaching Tracker'[App User]))
Regards
Phil