Parent child calculation

[borniex]

Hello!
It seems like a simple task but I can't figure it out, has anyone encountered this problem?
I am attaching a clear example. How can I calculate the two columns?

[barritown · Accepted solution]

Hello @borniex,

Assuming, the tables are not related in your data model, I could propose to create a couple of calculated columns like this one:

In plain text:

sum_parent = 
VAR CurrentParent = [parent] 
RETURN SUMX ( FILTER ( Data, [product] = CurrentParent ), [value] )

sum_child = 
VAR CurrentChild = [child]
RETURN SUMX ( FILTER ( Data, [product] = CurrentChild ), [value] )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

[borniex]

Thank you, the solution works! How and what should be transformed so that I can make it dynamic with a measure?

[barritown]

In case you use a table visual for that, such measures will do:

sum_parent = 
VAR CurrentParent = MIN ( Relationship[parent] )
RETURN SUMX ( FILTER ( Data, [product] = CurrentParent ), [value] )

sum_child = 
VAR CurrentChild = MAX ( Relationship[child] )
RETURN SUMX ( FILTER ( Data, [product] = CurrentChild ), [value] )