Forum Discussion
See users performance against only their submissions
Hi all,
Fairly new to Power Bi and I'm struggling for what might be a simple solution.
I have sensitive data so unable to attach screenshots but I'll do my best to explain.
I have a dataset which updates in a SharePoint list, it's a record of content created by content creators and each time they create new content it goes through and approvals process. The guys approving the content record the data on a form which shows the user who created the content.
What I want my PowerBI report to show when I select a content creators name it shows me as an example John smith has submitted 100 pieces of content 50 have been approved and 50 rejected. There has been 1000 submissions so based on that John has a 5% approval rating.
What I would like is a chart that shows when I click on John Smith he should have a 50% approval rating so that it's not comparing him to the overall stats but only his own.
I would appreciate any help on this and hopefully it's clear.
Thanks
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
6 Replies
- amitchandak
Super User
NitroMDX , 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?
amitchandak so I've tried this and it still shows their percentage of allowed/reviewed content against the overall total of submissions. I've attached a photo and in this example the user has made 95 submissions and what I would like to see is their percentage of allowed/review against their total of 95. Hope that makes sense
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
