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!

     

v-karpurapud's avatar
v-karpurapud
Icon for Community Support rankCommunity Support
1 year ago

Hi MurphyYancey 

We have not received a response from you regarding the query and were following up to check if you have found a resolution from the information provided below. If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank You!