Divide all rows by a row value

[Anonymous]

How can I divide account & month values ("Detail") by a specific Account (300) to get a resulting percentage?

The script below seems close but doesn't get me the expected results:

% Cost = 
VAR Account = SUM(Detail[Value])
VAR Liquid = CALCULATE(Sum(Detail[Value]), All(Detail),
FILTER(Detail, Detail[Account] = "300"))

Return
DIVIDE((Account), (Liquid),0)

Account	Month	Value	[Result]
100	Jan	1	.25
100	Feb	2	.5
200	Jan	2	.5
200	Feb	1	.25
300	Jan	4	1
300	Feb	4	1

[ValtteriN · Accepted solution]

Hi,

Try something like this:

% Cost =

VAR Account = SUM('Table (7)'[Value])

VAR Liquid = CALCULATE(Sum('Table (7)'[Value]), ALLEXCEPT('Table (7)','Table (7)'[Month]),

'Table (7)'[Account] = "300")

Return

DIVIDE((Account), (Liquid),0)

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/