Forum Discussion

andronachealin's avatar
andronachealin
Frequent Visitor
5 years ago
Solved

Calculated DAX column with multiple If statements

Hi all,   I would like to create a calculated column using DAX, titled Curriculum Status, that will apply the following logic: For each User ID (column C), if all course IDs in column B are mappe...
  • lbendlin's avatar
    lbendlin
    5 years ago

    I didn't understand this part " if all course IDs in column B are mapped to the curriculum in column A "  and it doesn't seem to matter for your desired result.

     

     

    Curriculum Status = 
var s = CALCULATETable(values('Table'[Course Status]),ALLEXCEPT('Table','Table'[User ID]))
return if(concatenatex(s,'Table'[Course Status],",")="Completed",s,"Incomplete")

     

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

=VAR _course=CALCULATETABLE(VALUES(sample[Course ID]),ALLEXCEPT(sample,sample[User ID])) VAR  _curri=CALCULATETABLE(VALUES(sample[Curriculumn ID]),ALL(sample),sample[Course ID] IN _course) VAR _status=CALCULATETABLE(VALUES(sample[Course Statues]),ALL(sample),sample[Curriculum ID] IN _curri,sample[Course Status]<>"Completed") RETURN IF(COUNTROWS(_status)>0,"Incompleted","Completed")