Forum Discussion
Pie Chart from Dynamic Measure
Hi Anonymous ,
I could not understand what is your desired result. Could you please post your desired result and offer some detail information about how to achieve it?
Regards,
Daniel He
- Anonymous7 years agoNot applicable
Hi Daniel,
I'll try to refrase it.
In the filter I selected 2 titles, in my real case I have groups of course titles with 50 or more different titles. Now, when I filter two titles I consider a user "completed" only if he completed both the titles. So in this case the piechart should show me that only one person out of 3 "completed" both the corses. (indeed in the bar graph on the right we can see only one that has %completed=1). The other 2 users with %completed=0 are considered "Not Started". In the piechart I should get the 3 status as legent and the count of ID as value, that in this case would be 33,33%Completed and 66,66% Not started.
For Reference: %Completed = CALCULATE(DISTINCTCOUNT(Table1[Course Title]) , Table1[Status] in {("Completed")} ) / COUNTA(Table1[Course Title])
Thanks for helping!
Monica