My DAX for the Margin is simply
Project Margin Pct = DIVIDE([Project Margin],[Total Revenue],0)
The proble I have is when the Revenue is Negative and the Project Margin is Negative, the Margin is showing as a positive, when it should really be a negative.
In Excel I would do something like…
=IF(‘Total Revenue’<0,-IFERROR(‘Project Margin’/‘Total Revenue’,0),IFERROR(‘Project Margin’/‘Total Revenue’,0))*100