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
Thank you, the solution works! How and what should be transformed so that I can make it dynamic with a measure?
barritown
Solution Sage
Solution SageIn 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] )