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.
Hi muelledg
Agree with HamedM1125.
Please provide sample data that covers your problem.
I have performed a simple test using data based on currently known information. There is no need to use measures to achieve the result you want.
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.
Hello. The sample data is below. Note that the data model looks like the figure below. The tables are linked on a unique ID called recid. Summary is a text variable that would not be used. The recid is numeric and is unique. v_rpt_Project is tablename and v_api_collection_time is tablename2. The PM_Project table is a bridge table.
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.