Total as per category,Region,date

Your solutions is so great danextian , allow me to add some detailed steps.
Hi, Anonymous 

First, you need to group your raw dataset in Power Query by following these steps:

1.Copy the original table

Select Group by:

Click Close and Apply:

Click on the new table and enter the following DAX expression:

Table 2 = 
VAR _table1 = SUMMARIZE('Table (2)','Table (2)'[Region],'Table (2)'[Total],'Table (2)'[Date],"category","Total"
)
RETURN UNION('Table',SUMMARIZE(_table1,'Table (2)'[Region],[category],'Table (2)'[Total],'Table (2)'[Date]))

Here are the results:

I've provided the PBIX file used this time below.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.