Calculate Sum of value based on Group

[Ramachandran]

Hi, How to calculate total value for group wise? I dont have any idea about it. some one suggest me.
I want to report data like,

fyi, First Category is more than one Sub Category but Second and Third  Category only one Sub Category.

thanks,

Ram 

[v-yalanwu-msft · Accepted solution]

Hi, @Ramachandran ;

May be you could create two measures:

Salesv = 
IF(ISINSCOPE('Table'[Category]), IF(ISINSCOPE('Table'[Subcategory])||MAX([Category])="First",SUM([sales])),SUM([sales]))

Salesv = 
IF(ISINSCOPE('Table'[Category]), IF(ISINSCOPE('Table'[Subcategory])||MAX([Category])="First",SUM([sales])),SUM([sales]))

The final output is shown below:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[serpiva64]

Hi,

you only need to add a Matrix like this

with this rows and this values

and deselect Stepped layout

[Ramachandran]

I don't want to see the second and third rows total. I need a First category total and Overall category total.

any other is it possible to achieve on this?