Forum Discussion
Calculate Story Point Value between two tables
Hi Anonymous ,
Here are the steps you can follow：
1. Create measure.
Measure = var _count= CALCULATE( COUNT('Data Table1'[Work Item ID]), FILTER(ALL('Point Table2'),'Point Table2'[Tags1]=MAX('Data Table1'[Tag]))) return _count * MAX('Point Table2'[Points])Measure 2 = SUMX( VALUES('Data Table1'[Tag]),[Measure])2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Anonymous ,
Not very clear about the structure and relationship between your other two tables, if [Value] and [ID] are in the same table, you can directly MAX('True1'[ID]) * MAX('True1'[Value])
If in different tables, you can consider to use the connection field between two tables, use measure to get [Tags.1] in table A to group to get the corresponding connection field, and then get the [ID] grouped in table B through the corresponding connection field.
If it doesn't meet your desired outcome, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Updated main post with some dummy data - I couldn't load it as a PBIX file but hopefully this works