Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
bdd9
Frequent Visitor

need DAX measure to multiply qty for each row in fact table by a value in my item lookup table

I need a DAX measure to multiply qty for each row in fact table by a value in a lookup table.

Basically similar to excel using a vlookup (RELATED function hasnt worked for me in a measure)


I'd like to do this without merging the fact and dimension table.

I assume there is an easy way to do this, but I cannot figure it out.

thanks

1 ACCEPTED SOLUTION

Thanks for offering help.

 

I was able to resolved my issue with this syntax. Previously, for some reason I was not able to get RELATED to work but I ulitmately did.

 

Here was my solution:

sumx(NS_Transactions,NS_Transactions[Qty]*RELATED(NS_ITEMS[QtyMultiplier]))

View solution in original post

2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

If they are related, try using RELATEDTABLE



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Thanks for offering help.

 

I was able to resolved my issue with this syntax. Previously, for some reason I was not able to get RELATED to work but I ulitmately did.

 

Here was my solution:

sumx(NS_Transactions,NS_Transactions[Qty]*RELATED(NS_ITEMS[QtyMultiplier]))

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.