Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Row context by agent and by customers

Hi everyone. I have an Issue: I need to make a distribution of Sales Agent Salaries by Customer. And the distribution it will depend the amount of sales of each customer of each agent from the tota...
Need Help
  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    3 years ago

    Hi Anonymous ,

     

    Thanks for your reply. That is because they are calculated by different values such as "Total Quantity ALL" and "Total Salaries".

    I marked them in the screenshot below.

    To solve this, you just need to add a slicer. Put "AgentKey" to the slicer and you will get the expected result.

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ xiaosun

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xiaosun-msft's avatar
v-xiaosun-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Anonymous ,

 

In the previous solution for you, I think the "table" of "I want to show it by Customer and a Table shape not Matrix and not by Agent" in your description is the visual shown below.

After looking at your example, I found that the two tables are both in Matrix and the measures you created is consistent with the solution I gave you. If you put them in a "table", it will show the correct result.

Or rather, maybe you want to show it by Customer and a Matrix??

 

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Okay, with those screenshots I saw that there is a behavior that I didn't know about that.
I put the second one as a table to be congruent with what I want.
Look, when I go to my example without filter:

 



But when I choose the customer in the Matrix, the numbers change. Can you explain me this?

 

  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi Anonymous ,

     

    Thanks for your reply. That is because they are calculated by different values such as "Total Quantity ALL" and "Total Salaries".

    I marked them in the screenshot below.

    To solve this, you just need to add a slicer. Put "AgentKey" to the slicer and you will get the expected result.

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ xiaosun

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Sorry for the delay, I was a little bit busy.

       

      The problem is that I add the Agent slicer, but brokes me some other measures that I have in the same report that are calculated by customer.

       

      Also, I have a lot of measures that are being summed by customer, but this measure that is calculated by Agent, is not summing the value of the customer only, it is summing the entire value of the agent.