Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Weightage based on unique value

Hi all, any advice in relation to the following problem would be greatly appreciated.   Background to problem:   I have a data table with portfolio ID column which there will be several customers...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    1 year ago

    Hi,

    Please check the below picture and the attached pbix file.

    It is for creating a calculated column.

     

     

     

    Weightage CC = 
VAR _portfolio = Data[Portfolio]
RETURN
    DIVIDE (
        Data[Nominal amount],
        SUMX ( FILTER ( Data, Data[Portfolio] = _portfolio ), Data[Nominal amount] )
    )
Kedar_Pande's avatar
Kedar_Pande
Super User
1 year ago

Anonymous 

Calculated column:

Weightage = 
'Table'[Nominal amount] / 
CALCULATE(
SUM('Table'[Nominal amount]),
ALLEXCEPT('Table', 'Table'[Portfolio])
)

💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn