Dax Measure help

[Anonymous]

I need to add 0.5 to a measure within a matrix table, however when I do that it keeps adding a year to the table with 0.5 in that column. Is there a way to add 0.5 to the dax measure without it creating a default value for other years and adding them to the table?

For example, the table has 2021 data and 2022 data 2021 has the data which needs 0.5 added to it. However, by adding 0.5 to the dax measure it adds the years 2019, 2020 and 2023 with 0.5 only which isnt accurate.

The Dax measure used is:

Weighted Average Profit Margin =

CALCULATE(

DIVIDE([IEA*PROFIT MARGIN], SUM('Detail'[IEA]))

+ (0.5))

[mahoneypat · Accepted solution]

FYI that you don't need the CALCULATE with that expression, but here is how to adapt it.

Weighted Average Profit Margin =
VAR wapf =
    DIVIDE ( [IEA*PROFIT MARGIN], SUM ( 'Detail'[IEA] ) )
RETURN
    IF ( ISBLANK ( wapf ), BLANK (), wapf + 0.5 )

Pat

[Anonymous]

Ah that's perfect thank you! @mahoneypat