Substract 2 measures when only when one is not blank, else return blank or 0

Anonymous — Fri, 07 May 2021 17:12:02 GMT

I have a matrix in which I have 2 measures and now I want to create a 3rd measure which gives me [measure1 - measure 2] only when measure 2 is not blank. If measure 2 is blank then measure 3 should also be blank.

Outcome

Department	employee	Measure 1	Measure 2	Measure 3
IT	John	10
IT	Ilse	20	50	-30
Finance	Jack	24	10	14
Finance	Josie	34	30	4
Finance	Jebaca	65
HR	Jay	65	50	15
HR	Jones	50

I have tried the measure below but is does not work unfortunatly.

Measure 3 =

VAR BB = [Measure 1]

VAR VC = [measure 2]

RETURN

IF (

NOT ISBLANK ( BB ),

BB - VC,BLANK()

)

I hope you can help me

Re: Substract 2 measures when only when one is not blank, else return blank or 0

AlB — Fri, 07 May 2021 20:29:39 GMT

Hi Anonymous

Measure 3 =
VAR BB = [Measure 1]
VAR VC = [measure 2]

RETURN
IF (
NOT ISBLANK ( VC ),
BB - VC,BLANK()
)

Please accept the solution when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

topic Re: Substract 2 measures when only when one is not blank, else return blank or 0 in DAX Commands and Tips

Substract 2 measures when only when one is not blank, else return blank or 0

Re: Substract 2 measures when only when one is not blank, else return blank or 0