Forum Discussion
Calculated Column Depends on another Calculated Column (Race condition)
Hi parry2k
Your reply was not the answer but it did lead me to it.
The problem was some of my Relations were way off, so I think Power BI couldn't figure out what was what.
But anyway thanks for pointing in the right direction 😄
Anonymous assuming you have a relationship between these tables and part number table is on one side of the relationship, you can add new column like this
New Scalar Column =
DIVIDE ( Order[Scalar Value], RELATED( PartTable[Total Scalar] ) )
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Hi parry2k
Your reply was not the answer but it did lead me to it.
The problem was some of my Relations were way off, so I think Power BI couldn't figure out what was what.
But anyway thanks for pointing in the right direction 😄
Anonymous glad it worked out, it is always tough to reply when looking at the problem because sometimes you don't have the full picture. Anyhow, the goal is to get you over the line and which seems like to be the case. Cheers!!
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Hi Anonymous ,
It seems that there is no relationship between two tables, right? You could try to refer to below expression to create calculated column
Column = CALCULATE(SUM('Order table'[Seller Scalar]))/MINX(FILTER('Part Numbers','Part Numbers'[Part Number]=EARLIER('Order table'[Part Number])),'Part Numbers'[Total Scalar])Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous glad to hear that issue is resolved, that's what matters. cheers!
