I have 1 column in my Nav_Item table called average selling price and I would like to multiply this by my Free Stock Value measure. For some reason when I perform this return answer is wrong... Anyone have any ideas? For example...
|Customer Name||Product Name||Average Selling Price||Free Stock Quantity||Stock Value|
Measure for Free Stock Quantity is using Total Quantity measure from my Nav_ItemLedger - Total TOB Approved Unposted from my Nav_SalesLine table here are the measures below...
Hopefully this is explained effectively and long story short...
'NAV_Item Ledger Entry'[Quantity]
'NAV_Sales Line'[Outstanding Quantity])
= Free stock Quantity and then get this Free stock Quantity * Average Sales Price....
Solved! Go to Solution.
Hi @tamerj1 , Thanks for replying!
This still gives the wrong answer, I'd assume this should give the correct one so it may be down to my data model then? I've tried everything and still can't manage to catch it.
Here is the relationship below...
And here are the tables...
No_Production GroupAverage Selling PriceProduct NameDocument No_Outstanding Quantity
No_Production GroupAverage Selling PriceProduct Name
Nav_Item Ledger Entry
Measures I have used so far...
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.