DB relationship in power bi

[ale_festa]

hey there, i'm new in power bi but i had used qlickview for many years. I've been load 2 tables join by one field and i added a new column in main table that merge 2 fields cod & description. in a matrix i had set that new column by row but drilling down seem dont use the relation between 2 tables

how can i solve it???

Thanks a lot

[leed · Accepted solution]

Hi @ale_festa ,

The formula that you use is in the 1 side of a many (SPESA) to 1 (PF_SPESA) relationship.

To be able to add a column to, you need to use a DAX formula that returns a table, like RELATEDTABLE.

If your many side contains multiple same value, you can use : PF_S_COMPLETO = MAX(RELATEDTABLE(PF_SPESA[ID_PIANO_FIN_S]))

Best,

DA