Donut chart based on measure

HI ravitejaballa ,

Current if statement does not support to use math and logical operators to calculate/compared with multiple values, I'd like to suggest you aggregate on these values or use INTERSECT, EXCEPT,CONCATENATEX functions to deal with multiple values calculation.

versionType =
VAR hedList =
    CONCATENATEX (
        VALUES ( 'HED-LEDVersions'[HED-LED Version] ),
        [HED-LED Version],
        ",",
        [HED-LED Version], ASC
    )
VAR mastCurr =
    CALCULATE (
        CONCATENATEX (
            VALUES ( MasterData[PresentVersion] ),
            [PresentVersion],
            ",",
            [PresentVersion], ASC
        ),
        MasterData[Software] = "HED-LED"
    )
VAR mastPrev =
    CALCULATE (
        CONCATENATEX (
            VALUES ( MasterData[PreviousVersion] ),
            [PreviousVersion],
            ",",
            [PreviousVersion], ASC
        ),
        MasterData[Software] = "HED-LED"
    )
RETURN
    IF (
        hedList = mastCurr,
        "Present",
        IF ( hedList = mastPrev, "Previous", "Old" )
    )

Regards,

Xiaoxin Sheng