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
Super UserNitroMDX , Can share what column you have. Based on that we can suggest. It might require a filter or all/removefilter to ingore of status in denominator
Measure 1 =
Divide( countrows(filter(Table, Table[Status] ="Approved") ), COuntrows(Table) )
Meausre 2
Divide(COuntrows(Table) , calculate(COuntrows(Table) , removefilter(Table[Status) ) )
Hi thanks for the reply.
I have tried this but it still shows the percentage worked out against the total submissions. What I'm trying to do when I select a single content creator is have a table showing their approval rating so if user X submits 100 pieces of content and 50 are approved when I select user X it will show a 50% approval rating. Using the above it's showing the percentage as 1.96% approval rating as I s measuring it against all submissions by all users.
Anything I can do to resolve that?