Dax calculation help required when comparing two columns from two different tables with no relation?

[ashmitp869]

Hi, 

I've 2 tables with no relationship between them, I would like to create a measure to add one column Qualified in table DSR by checking the Skill Level and Skill Qualified.

DSR and Qualifications  is M:M relationship

Output result will be like below image

Created a calculated columns but not working

Qualified = 
VAR __Dkey = SELECTEDVALUE(DSR_DNQ[Key]) 
VAR __Qkey = SELECTEDVALUE(Qualifications[Key]) 
VAR _SL = SELECTEDVALUE(Qualifications[Skill Level])
VAR _SQ = SELECTEDVALUE(Qualifications[Skill Qualified])
VAR __RESULT =
   IF(__Dkey = __Qkey && _SL ="L",
        "Learner",IF(__Dkey = __Qkey && _SQ ="Q","Qualified","Not Qualified"))
        
RETURN
    __RESULT

Sample file : https://github.com/suvechha/samplepbi/blob/main/samplefile1.pbix

Thanks

[v-yilong-msft · Accepted solution]

Hi @ashmitp869 ,

I opened your .pbix file and created a calculated column.

Qualified =
IF (
    'DSR_DNQ'[Key] = "OBRIJA-8",
    "Learner",
    IF ( 'DSR_DNQ'[Key] = "OBRIJA-1", "Qualified", "Not Qualified" )
)

Then I think you can get what you want.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.