Trying to show data from 1 query into another linked query but only showing sum

[sntbcg]

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!

[amitchandak]

@sntbcg ,

you should create a common solution dimension and try

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...