Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have an issue when using the RELATED() function. I have a Many to One relationship between the table CON and the table MPPAYERS but when I try to create a calculated colum in MPPAYERS to get data from CON (for instance the column [CON_ID]) I have the following error : The name 'RELATED' wasn't recognized. And when I try to create a measure in my report, dooing the same, I have this error: The XXX column either doesn't exist or doesn't have a relationship to any table available in the current context.
Could you halp me please?
Hi @sophie63
I think RELATED() would work if you were creating the column in the CON table (the child table) and trying to refrerence data from the parent table. Whereas I understand REALATEDTABLE() is used from the parent table, or MPPAYERS in this case.
Cheers,
Phil
Hi @Greg_Deckler,
Because I can not see your detail resource data, I try to reproduce using the following sample table.
In Table, I want to get Table[QuantityA] value. It returns error when I use RELATED function, there are mutiple Table4 values for each row in Table. I must use a aggregated function. Just as @Greg_Deckler posted, I use the following formula and get expected result.
Result = SUMX(RELATEDTABLE(Table4),Table4[QuantityA])
If you have any issue, please let me know.
Best Regards,
Angelia
Try RELATEDTABLE
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |