Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I've created a measure that multiplies TotEndingInventory (wish is a meassure) by TotStCost ( which is a measure as well) But, when I put that measure in a table, the grand total is performing its original function (that is TotEndingInventory * TotStandarCost instead of summarizing the individuals row values.
According with the screenshot below, the total of TotEndingInventoryVal column is $211 437, which is the result of TotEndingIventory * TotStCost, instead of $72 945, which is the SUM of the row values in this column...
Can anybody help me please?
Tks in advance.
Solved! Go to Solution.
Hi,
Try this
=IF(HASONEVALUE([SAPMaterial]),[TotEndingInvValue],SUMX(SUMMARIZE(VALUES([SAPMaterial]),[SAPMaterial],"Total",[TotEndingInvValue]),[Total]))
Hope this helps.
Hi,
Try this
=IF(HASONEVALUE([SAPMaterial]),[TotEndingInvValue],SUMX(SUMMARIZE(VALUES([SAPMaterial]),[SAPMaterial],"Total",[TotEndingInvValue]),[Total]))
Hope this helps.
It it working. Thank you so much
Hello @arcejames
Are the amounts that are feeding into your two measures [TotEndingInventory] and [TotStCost] in the same table as the SAPMaterial field?
I will assume this is the case and the table is called Sales.
You will want to use an iterator over your table to do the calc, something like
TotEndingInvVal2 = SUMX ( Sales, Sales[EndingInventory] * Sales[StCost])
Please note that the EndingInventory and StCost in my measure are the columns in the sales table, the ones you sum in your existing measure.
If I have missed the mark, please share a sample of your model so we can help further.
Can you please share your measures and/or a mock dataset?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |