Hi,
I'm attempting to build a view in my report that will display the # of hours saved for each "solution". The # of hours saved is stored in one query (Query 1) and the solutions in another (Query 2). The relationship is a many to one relationship by a URL ID (Sharepoint) as many solutions in Query 2 can be linked to one page in Query 1.
Ex:
Solution A saves 10 hours a year.
Solution B saves 15 hours a year.
What I want to see:
| Solution Name | # of Hours Saved |
| A | 10 |
| B | 15 |
However,
When I create a matrix with "Solution Name" in the row and "Hours Saved" in the values - it aggregates it to the sum.
| Solution Name | # of Hours Saved |
| A | 25 |
| B | 25 |
I'm not sure why this is happening, I see the column is summarized by sum but changing it to don't summarize doesn't change anything.
Very new to Power BI so I hope I explained this well, would appreciate any assistance!
