Forum Discussion
See users performance against only their submissions
Hi NitroMDX ,
According to your description, you want to calculate the ratio of Approved and Rejected relative to the total of creations for the selected creator, rather than the ratio relative to the total of creations for all creators?
If I understand correctly, you can try this method.
Create a measure.
ratio = DIVIDE( COUNTROWS(Created), CALCULATE( COUNTROWS(Created), ALLEXCEPT(Created,Created[Creater]) ) )When I selected no creator, the pie chart calculated based on the total.
When I selected a creator, the pie chart calculated based on the total about selected creator.
——————————————————————————————————————————————————
If my answer helps you solve the problem, please accept my answer as a solution and let it be seen by more people in need.
Best regards,
Mengmeng Li
Hi NitroMDX ,
According to your description, you want to calculate the ratio of Approved and Rejected relative to the total of creations for the selected creator, rather than the ratio relative to the total of creations for all creators?
If I understand correctly, you can try this method.
Create a measure.
ratio = DIVIDE(
COUNTROWS(Created),
CALCULATE(
COUNTROWS(Created),
ALLEXCEPT(Created,Created[Creater])
)
)When I selected no creator, the pie chart calculated based on the total.
When I selected a creator, the pie chart calculated based on the total about selected creator.
——————————————————————————————————————————————————
If my answer helps you solve the problem, please accept my answer as a solution and let it be seen by more people in need.
Best regards,
Mengmeng Li
Anonymous for me this is still showing it based on the total. Am I doing something wrong here?
Hi NitroMDX ,
Is it the Creator Name column? If not, change it to be the Creator Name column.
Drop a pie chart on this page, then select a creator bar and see if the pie chart changes. In my test, my bar chart on the left is the total number of entries for each creator, not sure if your bar chart here is the same. The data is filtered by the value of the bar chart's X axis when you select a bar.
Best regards,
Mengmeng Li