Forum Discussion
sum by group
Hi muelledg
Perhaps the request was not clear enough in my previous reply.
We need to know what data is being used in the measure you are having problems with (not limited to relationships between tables). Based on the screenshot, we are not sure [summary] [index] [hours] correspond to which fields in your actual data.
Please share your pbix file if you don't mind. This is the quickest way for us to understand your problem. Alternatively, please provide the dummy data in tabular form that maintains the same data structure as the three actual data tables.Thank you for your understanding.
How to Get Your Question Answered Quickly - Microsoft Fabric Community
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Hamed. I don't think I provided enough information. As a result, that DAX statement does not quite provide me what I want.
So, oddly that works in one table visual, but not the other. In one visual, it displays a column that sums exactly as described (by Summary). However, in another table it displays the sum of all of the values. For example,
Table Visual 1 - This table uses only columns from the tablename table in the data view.
| Summary | Hours |
| Architect | 22 |
| Sales | 15 |
| Engineer | 4 |
| Total | 41 |
Table Visual 2 - This table uses only columns from a different table in the data view. Call it tablename2. When I enter the measure in this table it displays as follows. Selecting "Don't Summarize" results in an expanded table that lists every data element for the Hours column which is not what I want.
| Summary | Hours(tablename) | LastWeekHours(tablename2) |
| Architect | 41 | 7 |
| Sales | 41 | 8 |
| Engineer | 41 | 9 |
What I want is this:
| Summary | Hours(tablename) | LastWeekHours(tablename2) |
| Architect | 22 | 7 |
| Sales | 15 | 8 |
| Engineer | 4 | 9 |