sum if row header matches in measure

[Anonymous]

Hi Experts,

I need to sum the value and show it to only on row headers.

below is my example data.

Need to create measure and if row header matches then sum the unique value and display.

Pls help me on this.

Regards.,

Swamy

[Fowmy]

@Anonymous 

Check the following measure:

Total = SUMX( VALUES( Table[C%R] ) , [C%R] )

[amitchandak]

@Anonymous , Not very clear you can get subtotal using

calculate([Meausre], removefilters(Table[Cost center code]))

calculate([Meausre], filter(allselected(Table) ,[business] = max(Table[Business])) )

you can use isinscope to control

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

or

[Anonymous]

@amitchandak 

I just want to show total value to the row headers only which is "Crude", and the cost center values should be 0.

Regards.,

Swamy

[Anonymous]

Hi Experts,

any idea ?

Regards.,

Swamy

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

Please add another measure formulas as below:

Result = If(ISINSCOPE('Table'[Cost_Center_Code]),0,[M_C&R])

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