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?