Measure to change values in subtotal and grand total

[dobregon]

Hi guys,

I have a type of matrix visual with parent and child, in order to do some drill downs. The problem is that the parent shouldn't have the sum values of their childs (they have their values). I'm looking for a dax measure that can give me the positibility to change the column or other measure where i take the values for the subtotal and total for the matrix table.

something like.. if it is subtotal take this measure, if not, take this one and if it is grand total, take this.

is it possible¿?

[amitchandak]

@dobregon , Refer, if this can help

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

[dobregon · Accepted solution]

thanks @amitchandak i have done a mixure.

To create the levels and remove the blanks created in the levels i have used the following link

https://www.daxpatterns.com/parent-child-hierarchies/ 

This is the most important challenge becase we have 3 types of data

- Event parent that should have a child event

- Event child that should have a parent event

- Individual events without parent/children

So, the Lv001 will be event parent and individual events

Lv002 will be only childs from parents and for the rest should be Blanks. 

Then to remove the blanks i have followed the info in the link with maxdeph, path, etc.

To solve the other problem that it is to create a a measure that if it is parent need to read the parent info and if it is child need to reed different column. To do that i have used countrows. if countrows = 1 need to read child info (or individual events) and if controws > 1 need to read parent info.

I will close the topic, thanks for help. the idea of the isinscope is really usefull bit in this case we can't use it due to the lv001 have 2 different things (parents and individual events).

Regards!