I have created two measures in the same table: severity and frequency. I'm trying to get the formula to get the product of the two. But it gives me incorrect results.
My formula is : [Avg Severity] * [ Average Frequency]
Go to Solution.
I suspect that your results are actually correct but, due to rounding, they look incorrect in the table.
Try increasing the level of precision (decimal places) of your two base measures, I'm sure you'll see that your 'Loss Cost' measure is correct.
Proud to be a Super User!
View solution in original post
That is right. Thanks a lot 🙂
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.