Forum Discussion

MurphyYancey's avatar
MurphyYancey
Frequent Visitor
1 year ago
Solved

Subtotal Matrix Percentages by Another Total

Hi everyone! Relatively new to PowerBi and this task has me stumped. I'm trying to create a percentage column that gets the percentage of each Sub account by the Main Account. I don't even know if th...
Need Help
  • v-karpurapud's avatar
    v-karpurapud
    1 year ago

    Hi MurphyYancey 

    Please try the below DAX:

    % of Sales = 
DIVIDE(
    SUM('Table1'[Amount]),
    CALCULATE(
        SUM('Table1'[Amount]),
        ALLSELECTED('Table1'[GL Account], 'Table1'[Account Description]),
        'Table1'[Account] = "Sales"
    )
)

     

    I hope this meets your requirement. If this doesn’t fully solve your issue, please share a sample of your data and more context so we can provide a more precise solution.

    If this post helps, kindly mark it as Accepted Solution.

    Thank You!

     

techies's avatar
techies
Icon for Super User rankSuper User
1 year ago

Hi MurphyYancey something like this

 

% of Main Account Total =
DIVIDE(
    SUM('Sheet1'[Value]),
    CALCULATE(
        SUM('Sheet1'[Value]),
        ALLEXCEPT('Sheet1', 'Sheet1'[Account])
    )
)