Forum Discussion
SUMX by string from another table column
Hi Friend,
I have problem with sumx formula. I need to sum the delivered amount by contract from another table.
The problem that there can be not only one contract number, so I need to sum by string, what is not allowed in calculate formula.
Could you help me with it ?
Data table relations:
Best regards,
Kristina
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])))
2 Replies
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])))
Thanks, I have found another solution but this was also helpful
