Forum Discussion
Solved
Calculated column sum from other table based on other column value
Hi, I'll try to explain what I need. I have a table which contains some target value. I would calculate a value based on other table depending on "Cd_CACda" column. So, this is the calculated...
Please try:
Allocazione_1 = VAR ONF = CALCULATE(SUM(QUERY_CostiIndiretti[Importo]), FILTER(ALL(QUERY_CostiIndiretti), QUERY_CostiIndiretti[CentroAnalisi] = "OF001")) RETURN IF(Allocazione_Ordine[Cd_CACda] = "AMM001",ONF,0)If the problem persists,could you share the sample pbix with dummy data?
Please remove any sensitive data before uploading.
amitchandak
Super User
Super UsermespoKTM , is there a relation between the two tables?
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
you have get column from one table another like
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
Hi amitchandak , thank you for reply. There is a relationship through registry table.
For example: in the column "Allocazione_1" I want the sum of value related to "ONF001" from another table. The other table is this: