Forum Discussion

KenHoopes's avatar
KenHoopes
New Member
8 years ago
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...
  • pawel1's avatar
    8 years ago

    will that work?

     

    late = CALCULATE(
        COUNTROWS (usertasks),
            FILTER (usertasks, usertasks[status] <> "Completed" && usertasks [enddate]<TODAY()) )