Calculate % of Gran Total per Week

[actt]

Good morning,

I would like to calculate the % of Gran Total (per week) for the Intake. I tried to use the powerbi pre-filled calculation but it's not working when we have more than 1 week. So I would like to have a new column with the % of gran total (1% to 100%) for each week.

Anyone can please support? Thanks!!

[v-jianboli-msft · Accepted solution]

Hi @actt ,

Based on your description, I have created  a simple sample:

Please try:

GT% = 
var _a = SUM(FactTable[Intake])
var _b = CALCULATE(SUM(FactTable[Intake]),ALLEXCEPT(DimDate,DimDate[Week]))
return DIVIDE(_a,_b)

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.