Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |