Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
@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...
User | Count |
---|---|
73 | |
70 | |
38 | |
23 | |
23 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |