Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Bambroo69
Frequent Visitor

RELATED NOT WORKING with a Measure

‎08-25-2023 01:09 PM

Hello, I am trying to calculate the revenue using [Quantity Sold] *Products[product_retail_price].

Quantity Sold Measure= SUM(Transaction_Data[quantity])
Product_retail_price sits in another product table.
 
But, Power BI Doesn't give me an option to use [Quantity Sold]* Related(Product_retail_price). Is it because Related Function needs some sort of row context? Also, I am able use this under below DAX. Is it because SUMX is providing a row context by scanning Transactions table row by row?
Revenue= SUMX(Transaction_Data,[Quantity Sold]*Related(Products[product_retail_price]))
 
Bambroo69_0-1692994132577.png

 

Labels:
Message 1 of 2
146 Views
0
1 REPLY 1
parry2k
Super User
Super User

‎08-25-2023 01:55 PM

@Bambroo69 do this:

 

Revenue= SUMX(Transaction_Data,Transaction_Data[Quantity]*Related(Products[product_retail_price]))


Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 2 of 2
111 Views
0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

View All