Dax Measure help

Question

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 Answer

FYI that you don't need the CALCULATE with that expression, but here is how to adapt it.
&nbsp;
Weighted&nbsp;Average&nbsp;Profit&nbsp;Margin&nbsp;=VAR&nbsp;wapf&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;DIVIDE&nbsp;(&nbsp;[IEA*PROFIT&nbsp;MARGIN],&nbsp;SUM&nbsp;(&nbsp;'Detail'[IEA]&nbsp;)&nbsp;)RETURN&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(&nbsp;ISBLANK&nbsp;(&nbsp;wapf&nbsp;),&nbsp;BLANK&nbsp;(),&nbsp;wapf&nbsp;+&nbsp;0.5&nbsp;)
&nbsp;
Pat
&nbsp;

Forum Discussion

Dax Measure help

2 Replies

Related content

DAX Measure

POWER BI DAX MEASURE

Dax measure help

Help to create DAX Measure

DAX Calculated Measure