Forum Discussion

NitroMDX's avatar
NitroMDX
Regular Visitor
1 year ago
Solved

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 datas...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
1 year ago

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) ) )

NitroMDX's avatar
NitroMDX
Regular Visitor
1 year ago

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