How to calculate TOTAL for table with slicer?

[byWing]

Hi All,

I understand calculating the TOTAL in PowerBi is always a challenge. But being new to DAX doesn't help. 

I have read so many posts but I am not getting anywhere. I think it's something with SUMX but I have tried many different versions, and it still didn't work. =(

So will really need some help with this please:

Here is what I have in a database (simplifed version):

Desired outcome when put into a matrix/ table:

Desired outcome when I use my slicer to filter by sites on the matrix/ table:

What kind of DAX do I write please?
Thank you so much in advance!~

[v-cgao-msft]

Hi @byWing ,

Power BI will automatically merge the categories. To display them this way, you need to add an [index] column in the PowerQuery Editor.]

Then drag these fields into the table.

Finally, adjust the font color of the [index] column to match the background color.

If Total is not correct, try this measure.

Measure = 
SUMX(
    SUMMARIZE(
        'Table',
        'Table'[Site],
        "bugt",[@Budget]
    ),
    [bugt]
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum