Forum Discussion

MWilliams's avatar
MWilliams
Frequent Visitor
7 years ago

Stop Values from Aggregating

Hi, I am trying to create a matrix in which employee hours are tracked by work category.  There is a value that shows percentage of hours per work category out of employees total hours.  I would then...
Need Help
v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi MWilliams,

From your data and description, it could work normally on my side:

Could you please share your pbix file to have a test if possible?

 

Regards,

Daniel He

 

 

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    7 years ago

    Hi MWilliams,

    It seemed the format of your [Salary], [Tax] and [401k] showed as text, you need to switch them to number:

    Then I could not figure out the relationships you have created in your pbix, I used the 'Business Unit Master' [Column1] to show the subcolumn:

    Hope it could help you.

     

    Regards,

    Daniel He

    • MWilliams's avatar
      MWilliams
      Frequent Visitor
      7 years ago

      v-danhe-msft Your output has the same problem mine has.  

       

       

       

      The 4090 should be split up proportionally to the hours.  I.E. for Category 41 Salary should be roughly 2550 and for Category 45 roughly 1540.  

       

      As for my relationships, all I did was create separate sheets as masters of ResourceName and Categories because they were not unique within any other data sources.  

       

       

      Edit: to be clear, my problem is two fold.  The first is getting salary, tax, and 401k to show up proportionally per category.  The second is to fix summarization.  4090 is the entirely wrong number, the values are summarizing as first and don't summarize is not an option.