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")

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Please try this column expression

 

Status =
VAR vIncompleteRows =
    CALCULATE (
        COUNTROWS ( Table ),
        ALLEXCEPT (
            Table,
            Table[User ID],
            Table[Curriculum ID]
        ),
        Table[Course Status] <> "Completed"
    )
RETURN
    IF (
        vIncompleteRows > 0,
        "Incomplete",
        "Completed"
    )

 

Pat