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 
Thank you for reaching out to the Microsoft Fabric Community Forum.
 

Regarding your query on creating a subtotal Matrix Percentages by Another Total , while I’m not fully aware of the exact structure of your dataset, I’ve created a sample .pbix file to demonstrate one possible solution.

Try the below DAX:

% of Sales = 
DIVIDE(
    SUM('Table'[Amount]),
    CALCULATE(
        SUM('Table'[Amount]),
        'Table'[Account] = "Sales"
    )
)

 
I’ve attached a screenshot and the .pbix file demonstrating this logic. Please review them to see if this solution aligns with your requirements.

 

If this doesn’t fully meet your needs, could you kindly share a sample of your data and more detailed context? That would help us provide a more accurate solution.

 

If this response resolves your query, kindly mark it as Accepted Solution to help other community members. A Kudos is also appreciated if you found the response helpful.

 

Thank You!