Divide rows (calculated column) with different parameters

[ckolahi]

Hi Guys

I have the table below. The idea is to create a calculated column (in blue) to represent Actuals (A) vs Budget (B), for each month, quarter, product, reps etc..

Any ideas

Thanks

[ckolahi]

@Anonymous 

super thanks it works. However I think y example was misleading. What would be if the B value was not the Max value ? 

 I tried to create variable actuals (A) vs (B) with FILTER function, was not successful.

If any ideas please feel free.

Thanks

[Anonymous · Accepted solution]

Hi ckolahi

Please try this code

Desired =

var maxamt=calculate(max(Feuil2[Value_SIP]),ALLEXCEPT(Feuil2,Feuil2[Names],Feuil2[Measure SIP],Feuil2[Month],Feuil2[Year]))

return

divide(Feuil2[Value_SIP],maxamt,0)