Forum Discussion
Solved
Parent child calculation
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?
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
3 Replies
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
Thank you, the solution works! How and what should be transformed so that I can make it dynamic with a measure?
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] )
