Sql query To Dax convert

[Anonymous]

hello everyone 

 i need help in conversion of sql query into dax expression 

select * from masterlist 

 where businessunit  in ( select businessunit from users

                                         where usermail = username())  or businessrecipient = usename()

thanx advance

[amitchandak]

@Anonymous , Try one or more measures like

measure =
var _tab = summarize(filter(all(users), users[usermail] in values(users[usermail]) || users[businessrecipient] in values(users[usermail])),users[businessunit])
return
calculate(countrows(masterlist), filter(masterlist, masterlist[businessunit] in _tab))