Forum Discussion
DAX Measure
I am trying to create a measure where when I place it in a Pivot Table the values are displayed properly and not the sum of the values. I have two tables, see below, and I want to multiply the Qty c...
- Have you tried using LOOKUP from Table 1 to Table 2 to bring in the price and then multiply that by the quantity? i.e. LOOKUPVALUE(Table2[Price], Table2[Description], [Description])
Have you tried using LOOKUP from Table 1 to Table 2 to bring in the price and then multiply that by the quantity? i.e. LOOKUPVALUE(Table2[Price], Table2[Description], [Description])
This indeed works when you bring it into the fact table. I was looking for a measure to write where I don't have to bring the variable into the fact table.
Thanks for the help and I'm marking this as solved!