Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Sum by two groups

Hi everyone , I need help with this issue i have a table visual: User level Salery A 1 34 B 2 32 B 2 37 C 1 26 C 3 28 C 1 29 D 3 33 E 1 30  if i re...
Need Help
v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi Anonymous ,

 

One point of confusion, if you remove the level column, Power BI will automatically calculate the Salery.

If i misunderstood you, please let me know and share your pbix file without sensitive data and expect result.

Best Regards

Community Support Team _ chenwu zhu

 

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

    • v-chenwuz-msft's avatar
      v-chenwuz-msft
      Community Support
      4 years ago

      Hi Anonymous ,

       

      Sorry, still don't quite understand what you want the result to look like. Please give what you want the result to look like, hand-drawn is fine.

       

      Best Regards

      Community Support Team _ chenwu zhu