Forum Discussion
DAX count filtered from a different table?
I have a table (usertasks) populated with users and task information. I have a table created in PBI that I need information from the usertasks table summarized in. I can't seem to make it happen. Examples of what I have in the first table and what I want in the second table are shown below. I was able to get a list of the users into the new table with the following command:
username = DISTINCT(usertasks[username])
The logic for late column should be only show the count for records that are not completed, are older than today, per the distinct usernames in the table.
Any assistance is appreciated.
will that work?
late = CALCULATE(
COUNTROWS (usertasks),
FILTER (usertasks, usertasks[status] <> "Completed" && usertasks [enddate]<TODAY()) )
3 Replies
- Any suggestions?
will that work?
late = CALCULATE(
COUNTROWS (usertasks),
FILTER (usertasks, usertasks[status] <> "Completed" && usertasks [enddate]<TODAY()) )In my environment, it will count based on that criteria, however, it does not appear to assign them to the username to which each late task is assigned. It simply has the same value for both the john and jane rows.
