If Statement with Column and Measure

gmasta1129 , That seem more like column not measure , Try a measure like

CALCULATE(SUM(daily_report[fx prv]), filter(daily_report,daily_report[master portfolio id] <> 729))
+ CALCULATE([Net FX P&L2], filter(daily_report,daily_report[master portfolio id] = 729))

Hi gmasta1129 ,

Your formula with IF function seems to be a calculated column, right? A calculated column is static, it won't be changed by the filter of the slicer. However, measures do. You could create a measure instead of the orginal calculated column.

What is the difference between Power BI calculated columns and measures? - TrueCue.

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.