Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Pie Chart from Dynamic Measure

Hi,   I'm analyzing e-learning data. I'm trying to build a visualization based on a measure, that can varies base on filters. With no success yet. In the second query we have the UserId and...
Need Help
Tips and Tricks
v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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