Forum Discussion
Helper VRecover a field from facttable in another facttable
Super UserWhich specific column are you trying to get value from? Also, please take note that a DAX calc column cannot return more than one row so the result must be aggreated by concatenation, min, max, etc. So if your filter criteria returns more than one possible row, you must decide which of the resulting rows to pick.
Helper VHi danextian ,
maybe this screenshot can help you to understand what I need:
Due to confidentiality I cannot share the table, but this is an extract of what I have in table 1 and what I want to recover in table 2. I hope this can clarify better my problem:
I filtered by "MES" because there are other values, but I'm only interested in this one. I want to recover value by value from table 1 not the result to add both values.
Thanks,
- danextian
What do you mean by value by value? You mean the two rows from table1? Please note that calculated columns cannot return more than than a single row. The result must be aggregated one way or another which is essentially what SUMX is doing your formula.
- jlarques
Yes, I want to recover 77,84€ and 12,97€ from table 1 to table2 in each row, because I have two rows in table 1 and same rows in table 2.
I think the problem is there is no difference betweem both rows to choose one of them.
- danextian
You can't do that with calculated columns. You can return only a single row - either the first or the secone one but not both.