Comma Separated Values

Hi Creative_tree88 

You can make use of PATHITEM and then some crossjoins.

-calculated table

DAXSplit =
VAR _Path =
    --add a pathitem column by substituting commas with pipes
    ADDCOLUMNS (
        'Table',
        "@PathItem", SUBSTITUTE ( 'Table'[Examinations], ",", "|" )
    )
VAR _MaxLength =
    --get the overall max path length
    MAXX (
        ADDCOLUMNS ( _Path, "@PathLength", PATHLENGTH ( [@PathItem] ) ),
        [@PathLength]
    )
VAR _Crossjoined =
    CROSSJOIN ( _Path, GENERATESERIES ( 1, _MaxLength, 1 ) )
VAR _ExamItem =
    FILTER (
        ADDCOLUMNS (
            _Crossjoined,
            "Exam Item", PATHITEM ( [@PathItem], [Value], TEXT )
        ),
        NOT ( ISBLANK ( [Exam Item] ) )
    )
RETURN
    SELECTCOLUMNS (
        _ExamItem,
        "Report ID", [Report ID],
        "Examinations", [Examinations],
        [Exam Item]
    )

Please see the attached sample pbix.