topic Re: Vlookup per category DAX in DAX Commands and Tips

Vlookup per category DAX

fosterXO — Tue, 17 Oct 2023 08:42:22 GMT

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.

Re: Vlookup per category DAX

Dangar332 — Tue, 17 Oct 2023 08:58:58 GMT

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.