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.
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]
Solved! Go to Solution.
Hi @Anonymous
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.
Best regards,
Martyn
Hi @Anonymous
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.
Best regards,
Martyn
That is right. Thanks a lot 🙂
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |