Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
DAX
divide
P&L
  • ValtteriN's avatar
    ValtteriN
    4 years ago

    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/

ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

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/