Forum Discussion
Divide all rows by a row value
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 |
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")ReturnDIVIDE((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/
1 Reply
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")ReturnDIVIDE((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/