Calculated Table Dax Code using Rollup needs Subtotal labels and sorting

Hi AndreasHermle,

Thank you for reaching out to the Microsoft fabric community forum.

This is a work around you can go with this:

You can use the GROUP BY feature in Power Query to calculate total sales for each Country and Category. Then, create subtotals by grouping just by Country and label these as "Subtotal." Finally, add a row for the overall total labeled "Total." Combine all these results into one table and sort it so the subtotals appear under each Country group for a clear summary.

You can find official documentation  and screenshot here for reference:

How to GROUP BY or summarize rows - Power Query | Microsoft Learn

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

Harshitha.

Community Support Team.