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

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.