Forum Discussion
Helper ISUMX by string from another table column
KristinaSp , That is not the ideal way to have a contract. You need to split that into rows and you need to take care of values when there is the same delivery number
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
you need measures like. Join based on contract id
Sumx(values(delivery[delivery no]),calculate(max(delivery[delivery value])))
Super UserKristinaSp , That is not the ideal way to have a contract. You need to split that into rows and you need to take care of values when there is the same delivery number
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
you need measures like. Join based on contract id
Sumx(values(delivery[delivery no]),calculate(max(delivery[delivery value])))
KristinaSpThanks, I have found another solution but this was also helpful