Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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] )
User | Count |
---|---|
59 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
87 | |
59 | |
52 | |
37 | |
21 |