First part of IF statement being ignored

[Anonymous]

Hi All,

I have the following measure:

Trading_FEE_Measure_Total = IF(YEAR(SELECTEDVALUE(DateTime_Calendar[Date])) >= 2025,-0.04*[Total cashflow before Fees_TNUoS_CM_Total],

SUMX(SUMMARIZE(R_BATTERY_SITES,R_BATTERY_SITES[SITE_NAME],"Trade fee", IF(R_BATTERY_SITES[SITE_NAME] = "Cowley BESS",SUMX(VALUES(DateTime_Calendar[Date]),[Trading_Fee_Measure_Daily]),[Trading_Fee_Measure_Daily])),[Trade fee]))

When I display this measure it is applying the second half of the IF statement to the entire dataset, rather than having anything that is after 2025  be 4% of Total Cashflow.

In the below image the figures for Trading Fee 2025 are what should be for anything after 2025, then anything before that should be the second half of the if statement.

[johnt75 · Accepted solution]

The issue is that there isn't a single value for date when you are grouping by year and month. You can instead check the value of the Year column

Trading_FEE_Measure_Total =
IF (
    SELECTEDVALUE ( DateTime_Calendar[Year] ) >= 2025,
    -0.04 * [Total cashflow before Fees_TNUoS_CM_Total],
    SUMX (
        SUMMARIZE (
            R_BATTERY_SITES,
            R_BATTERY_SITES[SITE_NAME],
            "Trade fee",
                IF (
                    R_BATTERY_SITES[SITE_NAME] = "Cowley BESS",
                    SUMX ( VALUES ( DateTime_Calendar[Date] ), [Trading_Fee_Measure_Daily] ),
                    [Trading_Fee_Measure_Daily]
                )
        ),
        [Trade fee]
    )
)

[Anonymous]

Thank you! This worked