Forum Discussion

aizamkamadin's avatar
aizamkamadin
Icon for Helper II rankHelper II
6 years ago

DAX using IN

how to convert this sql query into DAX   SELECT COUNT(USERID) as TotalNo, User_ID FROM project_User where UserID IN (Select UserID FROM project_User where ProjectID=22) GROUP BY UserID   Thanks...
AntrikshSharma's avatar
AntrikshSharma
Icon for Community Champion rankCommunity Champion
6 years ago

aizamkamadin Try this.

=
CALCULATE (
    COUNT ( project_User[USERID] ),
    project_User[ProjectID] = 22
)