DAX formula to use if you will get the same value from other field

[juhoneyighot]

Hello!

I need help what DAX formula to use if I will get the value of the Cost Recog field with the same value as with the actual Cost. Please see table below.

What I need is the Cost Recog value and this is the same value as with Actual Cost

Project	Actual Cost	Cost Recog
Project 1	$2,534,248.23	$2,534,248.23
Project 2	$1,633,649.00	$1,633,649.00

Thank you.

[Greg_Deckler · Accepted solution]

@juhoneyighot Maybe:

Measure = 
  VAR __Actual = SUM('Table'[Actual Cost'])
  VAR __CostRecog = SUM('Table'[Cost Recog])
  VAR __Result = IF( __Actual = __CostRecog, __CostRecog, BLANK() )
RETURN
  __Result