Calculating Total for by a Sub Category

[Anonymous]

Hi, I have a  table as below. I have to calculate Sub Total by ProductCategoryName and Display it beside each Line. Like Audio has three sub categories Bluetooth, MP4 and Recording Pen. Beside each Row it should show 15,40,44,157.84.

Thanks in Advance.

[Whitewater100 · Accepted solution]

Hello:

You can try:

subcategorysales = CALCULATE([TotalSales], REMOVEFILTERS(Products[SubCategoryName]))

I hope this helps..