Error when I try to get a value from another table

[CSpina]

Hi guys.

Maybe I dont know how to do it, but I need do get a value from one table to another. I have this table and I need to get this value in another table (red).

When I try to use this calculate:

fator_20 = CALCULATE(SUM(fatorSucateamento[fator]), FILTER(fatorSucateamento,fatorSucateamento[numero_anos]='fProdução'[anos_sucateamento]),fatorSucateamento[id_sucateamento]='fProdução'[id_sucateamento])

I am getting an error:

A expressão contém várias colunas, mas somente uma única coluna pode ser utilizada em uma expressão True/False usada como expressão de filtro de tabela.

 Any thoughts?

Thanks.

[v-zhenbw-msft · Accepted solution]

Hello @CSpina ,

In the Filter function, you are missing the "&&" symbol, try the following formula.

fator_20 = 
CALCULATE (
    SUM ( fatorSucateamento[fator] ),
    FILTER (
        fatorSucateamento,
        fatorSucateamento[numero_anos] = 'fProdução'[anos_sucateamento]
            && fatorSucateamento[id_sucateamento] = 'fProdução'[id_sucateamento]
    )
)

If you don't meet your requirements, could you show the exact expected result based on the table you shared?

Best regards

Community Support Team _ zhenbw

If this post helps,then consider Accepting it as the solution to help other members find it more quickly.

BTW, pbix as attached.

[CSpina]

Thanks very much, that´s it.

[Greg_Deckler]

@CSpina You need to use RELATED, RELATEDTABLE or LOOKUPVALUE when referring to those columns in another table. The error you are getting is because you are essentially returning all of the rows of that table and then trying to compare it to something.

[amitchandak]

@CSpina , can provide some sample data.

You can copy in the following way

examples

// from item to sales - from Item on 1 side of 1 to M

Item Name = RELATED('item'[Brand])

//month to sales 1 to M

Month Name = LOOKUPVALUE('date'[Month Year],'date'[Date],Sales[Sales Date])

// from City to sales  1-M. But also possible in m-1 or M to M. filter need to key filters , you can use sumx, minx xountx too
City Name = maxx(FILTER(geography,geography[City Id]=Sales[City Id]),geography[City])