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 feel bad asking this because I have done some solid intermediate dax and powerbi work, but this has stumped me.
I have a Measure called "Excess Loss" that calculates my excess loss over my insurance retention for each accident. (Think of it like stock options where each year the option price is different). Since it is a measure and not a calculated column, PowerBi is calculating the incorrect value for TOTAL Excess loss.
Here is a screenshot where the green highlights represent correct calculation, red is incorrect.
All I am trying to get is a single total for excess loss so I can make it into a KPI / CARD visual in PowerBi. Is there a formula to calculate the sum of a current measured column?
@Anonymous
If the first 4 columns in the snapshot are from the source, to achieve the required output, you can follow below steps.
The only problem is the count of Claims total =242 in the snapshot, which looks obviously incorrect for me. Can you explain it?
Post your DAX formula.
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |