Vlookup per category DAX

[fosterXO]

I have the following table. Column 3 (qty) is the sum of individual rows.

I would like to create a measure that displays the info like column 4 (Measure). I want to display the sum of value of Product_2 per customer Name. For Customer_A it shows 10 for every row because that is the value of Product_2.

[Dangar332 · Accepted solution]

hi, @fosterXO 

try below  just adjust table and column name

result =

CALCULATE(SUM('product'[qty]),'product'[product type]="pr_2")

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.