Forum Discussion
sum by group
- Anonymous1 year ago
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.
muelledg
Try this Dax!
HERTP =
SUMX(
VALUES(tablename[Summary]),
CALCULATE(SUM(tablename[Hours]))
)