Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Need help Finding a Formula to use

I have this data that I want to use. I want to create visulizations by division but as you can see two providers work at multiple locations. How can I make sure those people are routed to the c...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Can you elaborate on what you are worried about and what you would like to see happen?
Theoretically, they could be routed to the correct division. what visual objects do you intend to create? What values are you going to put into the visual objects?

Best Regards,
Dino Tao

Anonymous's avatar
Anonymous
Not applicable
2 years ago

When I use a matrix table to show the values for each division, it is combining the providers values and showing the total in each division.

 

Ex: Moore has 21 units for division ABC and 12 for division BBB. When I use the matrix to look at units by divisons instead of showing that Moore as 21 for ABC & 12 for BBB, it is showing 32 for ABC & 32 for BBB.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    I'm sorry but could you show me how you created the matrix? I've tested it and I don't have any problems with it.

     

    Best Regards,
    Dino Tao
    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
      2 years ago

      This is how I created the matrix. Maybe its because I am using multiple data tables? I am not sure.

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      I see that in your power bi file that the units are in the same table as the providers, location and division. My unit data and providers, location & division are in two different tables. How can I get this solved? I do not want to add the providers, locations and divisions to my raw data table.