Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Replacing blanks with value based on ID

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 

 

Need Help
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    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

6 Replies

  • SpartaBI's avatar
    SpartaBI
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      This only returned "False" 

       

      • SpartaBI's avatar
        SpartaBI
        Icon for Community Champion rankCommunity Champion
        4 years ago

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