Forum Discussion
Solved
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. Exa...
will that work?
late = CALCULATE(
COUNTROWS (usertasks),
FILTER (usertasks, usertasks[status] <> "Completed" && usertasks [enddate]<TODAY()) )
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.