Replacing blanks with value based on ID

[Anonymous]

Hey I'm trying to replace the blanks in the subtotal column with the subtotal amount that corresponds to the Order ID. I made a mock table of it here 

My goal is this 

[SpartaBI]

@Anonymous create this calculated column:

'Table'[Subtotal] = 
VAR _current_id = 'Table'[Order ID]
VAR _result = 
	SUMX(
		FILTER(
			'Table',
			'Table'[Order ID] = _current_id
		),
		'Table'[Price]
	)
RETURN
	_result

      

Showcase Report – Contoso By SpartaBI

[Anonymous]

This only returned "False" 

[SpartaBI]

@Anonymous can you PM me to look together in a zoom?

[SpartaBI · Accepted solution]

Oh, I see now you used my column name as part of the code.
You need to remove my name or the original column name.
Anyway you can PM me and we'll do it together in zoom

[Anonymous]

Got it after that message, thanks! 

[SpartaBI]

@Anonymous my pleasure 🙂
Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. 
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂