Replace all Blanks Based on Associated Cell Value

[choponbraves]

Hello Power BI gurus,

I need some help with this roadblock and greatly appreciate anyone's help.

The essential issue is simple-- i need to replace the blank values in 'ContractValue' and 'Misc' with their associated non-blanks anytime there is one present within the same column.  'ContractValue' and 'Misc' values should be uniform for each set of Project Id's, regardless of their Service Item.  In other words, 'ContractValue' should remain 0 in this instance while 'Misc' should populate with 8,100 for each row with a matching 'Project ID' (which is all of them in the example provided).  So there will only be one value for Misc or ContractValue whenever one exists for a project ID.  Can someone provide guidance on how to accomplish this?

[Fowmy · Accepted solution]

@choponbraves 

I assume Misc and Contract Value are measured? Create the following measures for each as follows

New Misc = 
MAXX(
    ALLEXCEPT(tablename, tablename[Project ID]),
    [Misc]
)
----------------------------------------------------------
New Contract Value= 
MAXX(
    ALLEXCEPT(tablename, tablename[Project ID]),
    [Contract Value]
)