Calculate Story Point Value between two tables

[JulieDuncan]

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

[v-yangliu-msft · Accepted solution]

Hi  @JulieDuncan ,

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

[v-yangliu-msft]

Hi  @JulieDuncan ,

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.

[JulieDuncan]

Updated main post with some dummy data - I couldn't load it as a PBIX file but hopefully this works