Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi everyone,
I've made the following table containing two items from the "Master" data sheet with product facts (Product Gegevens); ProductID and PurchasePrice. Also I've created a Running Total Measure "Totaal Voorraad". I'd like to multiple this measure (middle column) with the right colum (purchase price). The following formula won't be accepted, hence I've tried to use RELATED and RELATEDTABLE in order to make it work. This didn't do the trick unfortunately....
Does anyone has a solution for this issue?
Tyson.
@Anonymous
What is the relationship between the 2 tables, connect by which field? Is it possible to share the sample pbix.
Paul
Hi @V-pazhen-msft / Paul,
Thanks for your question. I'm not able to share a pbix file with you. However, I can send you this screenshot of the corresponding model. They're connected via the ProductID.
Hi @Anonymous
Measure =
[Totaal Voorraadd] * SELECTEDVALUE ( 'Product Sales'[Purchase Price] )
You must use the SELECTEDVALUE or MAX function to determine which row (which value) you want to multiply.
_______________
If I helped, please accept the solution and give kudos! 😀
Hi Ikalawski,
Thanks for your feedback, but it doesn't work yet. Both the table containing al ProductID's and the table with one ProductID sorted by date does not show a total stock value correctly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
61 | |
59 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |