Forum Discussion

IanGladden's avatar
IanGladden
Frequent Visitor
6 years ago
Solved

Producing a Pie Chart From a Calculated Measure

You will have to excuse me if some of the terminology is not correct but I'm not a programmer by any stretch and I'm trying to teach myself this package so I can make our school data more accessible ...
Need Help
  • IanGladden's avatar
    IanGladden
    6 years ago

    Thanks for the offer but I managed to produce what I wanted with a measure.

     

    PA = SUMX(VALUES(Attendance[External Id]),IF(AND(ISNUMBER(Attendance[%att]),Attendance[%att]<=.9),1,0))/SUMX(VALUES(Attendance[External Id]),IF(ISNUMBER(Attendance[%att]),1,0))

     

    Where External ID is the Unique ID, %att is a measure that calculates their % attendance.

Icey's avatar
Icey
Community Support
6 years ago

Hi IanGladden ,

If you don't mind, please share me some sample data or your PBIX file without sensitive information.

 

Best Regards,

Icey

  • IanGladden's avatar
    IanGladden
    Frequent Visitor
    6 years ago

    Thanks for your offer, apologies for the late reply but the email notification went into my junk folder.

    I'll produce a sanitised data PBIX file this weekend and send it on to you then.

  • IanGladden's avatar
    IanGladden
    Frequent Visitor
    6 years ago

    Thanks for the offer but I managed to produce what I wanted with a measure.

     

    PA = SUMX(VALUES(Attendance[External Id]),IF(AND(ISNUMBER(Attendance[%att]),Attendance[%att]<=.9),1,0))/SUMX(VALUES(Attendance[External Id]),IF(ISNUMBER(Attendance[%att]),1,0))

     

    Where External ID is the Unique ID, %att is a measure that calculates their % attendance.

    • Icey's avatar
      Icey
      Community Support
      6 years ago

      Hi IanGladden ,

      Glad to hear that. Please accept your reply above as a solution.

       

      Best Regards,

      Icey