topic Re: Parent child calculation in DAX Commands and Tips

Parent child calculation

borniex — Mon, 23 Oct 2023 15:12:52 GMT

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?

Re: Parent child calculation

barritown — Mon, 23 Oct 2023 19:53:22 GMT

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

Re: Parent child calculation

borniex — Tue, 24 Oct 2023 13:10:17 GMT

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

Re: Parent child calculation

barritown — Tue, 24 Oct 2023 15:23:15 GMT

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] )