Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to do dynamic left anti join?

Hi,  I want to perform dynamic left anti join in powerbi. I have an erollment table in which i have user's emails and courses in which users are enrolled in and i have second table called users in w...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Check for use opted for that course. But need a separate usee table for that

 

Enrolled = countrows(enrollment )

 

not enrolled =if(isblank(countrows(enrollment ) ) , User[user], blank() )

 

not enrolled count = countx(values(User[user]),  if(isblank(countrows(enrollment ) ) , User[user], blank() )  )

 

 

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Amit, I also need a drill down report to show the users details. Will this approach work then?