How to show Sum of required attribute element values as subtotal?

[Anonymous]

Hi team,

I have 3 attribute elements(which is coming from only one column)  on columns and 3 measure on rows in matrix , here Iwhen I enable subtotal row wise its calculating all 3 attribute element values but i need to calculate only 2 attribute elements as subtotal?

Please help me.

[dax]

Hi @Anonymous , 

You said you want to re-define the row subtotal, so I think your attributes should be in Row instead of in Column. Below is my sample, you could refer to it for details. If this is not what you want , please correct me and inform me more details(your sample and your expected output)

Best Regards,
Zoe Zhi

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

[Anonymous]

Hi Sir,

Thanks for your reply.

Please find the attached Screenshot my sample report. Here i wanted to calculate total as shown in the Screenshot.

But It should calculate  Chairs and Fans for each measure(Profit and sales).

Expected Calculation should be :

Profit Total = Chairs 10000+ Fans 12000 = 22000.

Sales Total = (Chairs 50000 + Fans 70000=  12000.

Thank You!!

[dax]

Hi @Anonymous , 

You could refer to my sample for details.

Measure 5 = IF(HASONEVALUE(T1[Attributes]), SUM(T1[amount]), CALCULATE(SUM(T1[amount]), FILTER(T1, T1[Attributes]<>"C")))

Best Regards,
Zoe Zhi

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

[Anonymous]

Hi Sir,

Thanks for the solution which you have provided.

Here you have taken Profit and Sales as a attribute values and the provided DAX 100% working. 

But in my scenorio data is like below

here iam facing littele difficut to achieve the rquirement.

I would be thankfull if you can help me on this.

Thanks!

Suresh.

[amitchandak]

@Anonymous , this should help

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

Also refer : https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/