Forum Discussion
Calculate Story Point Value between two tables
I have a two tables in Power BI - One shows a "tag" type with various inputs within it and another table that expresses the value I want to associate with the "tag" I want to get a value where the count of the "tag" is multiplied by the "point" value.
From Data below I would expect the Tag "Duplicate = 4*1", "Bulk Upload = 6*5", "New User = 8*3"
Data Table 1
| Work Item ID | Tag |
| 123 | Duplicate |
| 124 | New User |
| 125 | Bulk Upload |
| 126 | New User |
| 127 | New User |
| 128 | New User |
| 129 | Duplicate |
| 130 | Bulk Upload |
| 131 | Duplicate |
| 132 | Bulk Upload |
| 133 | Bulk Upload |
| 134 | Duplicate |
| 135 | Bulk Upload |
| 136 | New User |
| 137 | New User |
| 138 | Bulk Upload |
| 139 | New User |
| 140 | New User |
Points Table 2
| Tags1 | Points |
| Duplicate | 1 |
| New User | 3 |
| Bulk Upload | 5 |
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
3 Replies
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.