Forum Discussion

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
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.

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.