Split value of a id to other id with percent of other id with souce.

[hihi]

i have a table like: 

can everyone help me with dax to calculate this expression?

Thanks and best regards.

[Fowmy]

@hihi 

not enough details to understand the context and the requirements. Please show the column and row details in the spreadsheet to understand the formula

[hihi]

I'm sorry, that's my full table.

[v-shex-msft]

HI @hihi,

AFAIK, current power bi data model does not include row and column index and the Dax expressions not able to apply recursion calculations. You may need to do this type of calculation out of power bi, then getting data from calculated results.

Regards,

Xiaoxin Sheng