Donut chart based on measure

[ravitejaballa]

Hi Team,

I am trying to using measure in Donut chart. But it throws expetion as it returns more than one value.

I have a list of software versions data and master data which will tell latest and previous version.

I am trying to show number of latest, previous and old versions of a software in Donut chart.

Below is my Data source.

I have created various measures(as can see from screen shot) to determine Present, previous and old version.

and using this measure trying to bring Donut chart to show number of Present, Previous and Old versions.

m_PresentVersion =

var presentVersion = CALCULATE(VALUES(MasterData[PresentVersion]), MasterData[Software] = "HED-LED")

RETURN

presentVersion

m_PreviousVersion =

var previousVersion = CALCULATE(VALUES(MasterData[PreviousVersion]), MasterData[Software] = "HED-LED")

RETURN

previousVersion

versionType = IF(

CALCULATE(VALUES('HED-LEDVersions'[HED-LED Version])) = [m_PresentVersion],

"Present",

IF(CALCULATE(VALUES('HED-LEDVersions'[HED-LED Version])) = [m_PreviousVersion], "Previous", "Old")

)

Software	PresentVersion	PreviousVersion
HED-LED	MIQ HED-LED 01Nov2019	MIQ HED-LED 01Dec2018

HED-LED Version	softwareName
MIQ HED-LED 08Dec2017	HED-LED
MIQ HED-LED 01Nov2019	HED-LED
MIQ HED-LED 01Nov2019	HED-LED
MIQ HED-LED 01Dec2018	HED-LED
MIQ HED-LED 01Dec2018	HED-LED
MIQ HED-LED 08Dec2017	HED-LED
MIQ HED-LED 01Nov2019	HED-LED
MIQ HED-LED 08Dec2017	HED-LED
MIQ HED-LED 08Dec2017	HED-LED
MIQ HED-LED 05JUN2018	HED-LED
MIQ HED-LED 08Dec2017	HED-LED

[Anonymous]

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

[ravitejaballa · Accepted solution]

Hi,

No it didn't work out. As i am not able to add versionType measure to Donut chart (Legend / Values) .

But i followed a different approvach. I created master data as below.

Version	current
MIQ HED-LED 01Nov2019	Present
MIQ HED-LED 01Dec2018	Previous

Merged this with list of all HED versions (Left join on HED-LED Version).
Will get data as below.

and i am able to use CurrentVersion in Donut chart.

Which will show number of Present, Previous and Old versions.

HED-LED Version	CurrentVersion
MIQ HED-LED 01Dec2018	Previous
MIQ HED-LED 01Dec2018	Previous
MIQ HED-LED 01Dec2016	Old
MIQ HED-LED 01Dec2018	Previous
MIQ HED-LED 01Nov2019	Present
MIQ HED-LED 01Dec2018	Previous
MIQ HED-LED 01Dec2018	Previous
MIQ HED-LED 01Dec2018	Previous
MIQ HED-LED 01Dec2018	Previous

Thank you for your support.