SIGN function behaviour changing when in an if function?

Question

Hi All,&nbsp;Please can someone suggest why these 2 measures may display different results? (I'm getting 1 for "Test Measure 1" and 0 for "Test Mesaure 2". I think both measures should output the same number (i.e. "sign([Net Production])" )&nbsp;From sense checking the source data I think the result should be 0.&nbsp;Test Measure 1 = &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; calculate(if([Output] &lt;&gt; 0, sign([Net Production]), sign([Net Production])),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALL('Dim_Calendar'[Fiscal Period]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALL('Dim_Calendar'[Fiscal Quarter])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp;Test Measure 2 = &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; calculate(sign([Net Production]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALL('Dim_Calendar'[Fiscal Period]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALL('Dim_Calendar'[Fiscal Quarter])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp;Thank you for any help,&nbsp;PW

alexisolson · Answer

This does seem strange. Can you share a file that reproduces this issue?

Forum Discussion

SIGN function behaviour changing when in an if function?

1 Reply

Related content

DATESYTD function

CALCULATE function behaviour

function behavior

DAX Studio space after function name

function enable staging