Sum of total and subtotal based on rows in matrix view

[Anonymous]

Hi Team

 I am creating a matrix view with below data.

Matrix View

Dax which I have used to create the profit is 

Profit = SUMx(Sales,Sales[Sales]*0.05)

My query is - if I want to have different percentage condition for Region in same dax profit code - lets say for now it is calculating for all 5%, but when its shows for region subtotal - it should be 4.8% in the same profit column.

Is it possible by any ways? Please help.

Thanks and regards

RatanB

[amitchandak · Accepted solution]

@Anonymous , Try like

Profit = Switch( True() ,

not(Isinscope(Table[Country])) , SUMx(Sales,Sales[Sales]*0.048)

SUMx(Sales,Sales[Sales]*0.05)

)

Try to use isinscope

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

[Anonymous]

Could you please advise what line I should write in order to get "TOTAL" in "checking" column in front of "TOTAL" in region column?

Thanks and regards 

[Anonymous]

Let me check this in bigger data and multiple columns. the solution which you provided for the above data set, worked like cream. Kudos to you. Thanks a ton