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] )
    )
v-aatheeque's avatar
v-aatheeque
Icon for Community Support rankCommunity Support
1 year ago

Hi Anonymous 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.