Forum Discussion

ravitejaballa's avatar
ravitejaballa
Icon for Helper III rankHelper III
6 years ago
Solved

Donut chart based on measure

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

 

SoftwarePresentVersionPreviousVersion
HED-LEDMIQ HED-LED 01Nov2019MIQ HED-LED 01Dec2018

 

HED-LED VersionsoftwareName
MIQ HED-LED 08Dec2017HED-LED
MIQ HED-LED 01Nov2019HED-LED
MIQ HED-LED 01Nov2019HED-LED
MIQ HED-LED 01Dec2018HED-LED
MIQ HED-LED 01Dec2018HED-LED
MIQ HED-LED 08Dec2017HED-LED
MIQ HED-LED 01Nov2019HED-LED
MIQ HED-LED 08Dec2017HED-LED
MIQ HED-LED 08Dec2017HED-LED
MIQ HED-LED 05JUN2018HED-LED
MIQ HED-LED 08Dec2017HED-LED

 

 
Need Help
  • ravitejaballa's avatar
    ravitejaballa
    6 years ago

    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.

    Versioncurrent
    MIQ HED-LED 01Nov2019Present
    MIQ HED-LED 01Dec2018Previous

    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 VersionCurrentVersion
    MIQ HED-LED 01Dec2018Previous
    MIQ HED-LED 01Dec2018Previous
    MIQ HED-LED 01Dec2016Old
    MIQ HED-LED 01Dec2018Previous
    MIQ HED-LED 01Nov2019Present
    MIQ HED-LED 01Dec2018Previous
    MIQ HED-LED 01Dec2018Previous
    MIQ HED-LED 01Dec2018Previous
    MIQ HED-LED 01Dec2018Previous

     

    Thank you for your support.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      ravitejaballa
      Icon for Helper III rankHelper III
      6 years ago

      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.

      Versioncurrent
      MIQ HED-LED 01Nov2019Present
      MIQ HED-LED 01Dec2018Previous

      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 VersionCurrentVersion
      MIQ HED-LED 01Dec2018Previous
      MIQ HED-LED 01Dec2018Previous
      MIQ HED-LED 01Dec2016Old
      MIQ HED-LED 01Dec2018Previous
      MIQ HED-LED 01Nov2019Present
      MIQ HED-LED 01Dec2018Previous
      MIQ HED-LED 01Dec2018Previous
      MIQ HED-LED 01Dec2018Previous
      MIQ HED-LED 01Dec2018Previous

       

      Thank you for your support.