Implement Aggregate Sum column based on values from other columns

Hi,

I assume you want to create a new calculated column.

Please check the below picture and the attached pbix file.

Total Supplier Spend CC =
VAR _currentsupplier = Data[Supplier]
VAR _suppliertable =
    FILTER ( Data, Data[Supplier] = _currentsupplier )
VAR _maxsupplierspend =
    MAXX ( _suppliertable, Data[SupplierSpend] )
VAR _condition = Data[SupplierSpend] = _maxsupplierspend
RETURN
    SUMX ( _suppliertable, Data[SupplierSpend] ) * DIVIDE ( _condition, _condition )

Anonymous 

Please see the solution using a 'Measure':

Dax Code:

sumn =

VAR maxval =

MAXX (

FILTER ( ALL ( Data ), Data[Supplier] = SELECTEDVALUE ( Data[Supplier] ) ),

Data[SupplierSpend]

)

VAR summ =

CALCULATE (

SUMX (

FILTER ( ALL ( Data ), Data[Supplier] = SELECTEDVALUE ( Data[Supplier] ) ),

Data[SupplierSpend]

)

)

VAR conditions =

SELECTEDVALUE ( Data[SupplierSpend] ) = maxval

RETURN

IF ( summ * conditions > 0, summ * conditions, BLANK () )

 

 

Also, you need to enable 'Show Items with No Data' for supplier as I have shown in following image:

Also enable 'Don't Summarize' for all fields.

 

 

 

Please accept it as a solution if it matches your requirement🙂