Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX: Create new column based on multiple conditions from other table

Hi all,   Unfortunately, I wasn't able to help myself with existing posts or the documentation, so trying my luck here.. :smileyhappy:   I have two main tables that have a relationship on the ema...
Need Help
  • tarunsingla's avatar
    tarunsingla
    7 years ago

    See if this helps. You need one calculated measure here to compute the status and then use a Matrix visual (add Email from the Learners List to the Rows, Course and New Status from Enrollments list to Columns, and the New Status to the Values section of the visual).

     

     

    Make sure to Expand all down one level in the hierarchy  in the Matrix visual, to see data both at course and foundation level.

     

    Regards,

    Tarun

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi tarunsingla , that's already super helpful as an intermediate step. Now I need to be able to implement the certification logic based on a few IF / OR conditions.

 

E.g. Certification A is passed if (Course A Foundation and Course B Foundation) or (Course A Foundation and Course C Foundation) are passed.

 

So I pretty much need the values of the completed modules by learner to creat an additional column which says if a specific certification is passed based on the conditions. What would be the most efficient way to do this? :smileyhappy:

 

Thanks again!

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Short update: Managed to solve it now with a combination of LOOKUPVALUE() and SWITCH() statements and a few additional calculated columns in the learner table. So I have basically rebuilt your above visual, tarunsingla , with columns of 1s / 0s. Still using your solution with a UNICHAR tickmark for illustration purposes, though. So thanks a ton again!!