Forum Discussion
Dax Measure help
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 creat...
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
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
Ah that's perfect thank you! mahoneypat