Power BI - grouped sum by week

i´m trying to build a new table with a weekly sum but by a col "canal" so in the "total_semana" column you can see the sum of the week for each "canal", then calculate the weekly share by "canal".

i tried adding a new col called "wnum" for the week number and sum by it, but no success in the "total_semana" col so far.

Example data table

the folowing table show the expected result, red, sum by week, blue its share.

expected table

Thank you all in advance.

1 Answer

For your weekly total:

total_semana = CALCULATE ( SUM ( week_sum[suma_vta] ) , ALLEXCEPT ( week_sum , week_sum[wnum] , week_sum[Año] ) ) 

For your % of weekly total:

participacion_semanal = DIVIDE ( week_sum[suma_vta] , week_sum[total_semana] )