SUM Value needed on a greater than DAX needed for a further calculation

[HayleyG82]

Hi 

I am trying to create 2 end values from the below DAX's to calculate as one number, but they are not coming through as values, please can somebody help ?

2025 New business =

SUMX(

    'Measures Table',

    IF([2025 Bookings qty] > [Qty for 2024], [2025 Bookings qty]), 0

)

I am asking this if my 2025 bookings qty is greater than last years sales then give me the booking qty else 0 - it works but doesnt calculate it as a value ?

2025 remaining business =

SUMX(

    'Measures Table',

    IF([2024 remaining sales] >= [Qty for 2024],

  [2024 remaining sales]), 0

)

I am asking this if my 2024 remaining sales qty is greater then my actual 2024 sales then give me the remaining qty else 0 -  again it works but doesnt calculate it as a value ? - my end goal is the two together will calculate my 2025 forecast 

[BeaBF]

@HayleyG82 Hi! Try with:

2025 New business =
SUMX(
'Measures Table',
IF([2025 Bookings qty] > [Qty for 2024], [2025 Bookings qty], 0)
)

2025 remaining business =
SUMX(
'Measures Table',
IF([2024 remaining sales] >= [Qty for 2024], [2024 remaining sales], 0)
)

2025 Forecast =
[2025 New business] + [2025 remaining business]

BBF

[HayleyG82]

Hi Thank you fopr your reply, although this has thrown out my new business qty  and only added zero to the total ?