Forum Discussion
Multiply Column by Measure
Hi Anonymous ,
Yes, it's possible. You can have a try.
If you need a dynamic result that changes the result based on the slicer's filtering, it's best to create a measure to return the results. Because measures are dynamic and calculated columns are static.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I also need to mention the Inventory Turns Calc field is a variable. It will change based on the value used in my parameter.
Hi Anonymous ,
Yes, it's possible. You can have a try.
If you need a dynamic result that changes the result based on the slicer's filtering, it's best to create a measure to return the results. Because measures are dynamic and calculated columns are static.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you.
I did end up with creating the measure below calcuating just the fields all together.
Seems to be working however the total for each part is always a couple of dollars off. Appears to be a rounding issue. Is there anything I can do to stop the rounding?
Product Pricing = (SUM('replacementsByCounty'[replacements]) * 'Market Share'[%] / 'Inventory Turns'[I%]) * sum(demoChainPrice[invoicePrice])