Forum Discussion
Table visualization error due to missing relationship
Hi all! I need to display a table visual in Power BI with fields from the following tables: Tags, Models, and Spare Parts. If I add the Tags and Models fields or the Spare Parts and Models fields,...
Hi Fern_21 - Since the tags table isn't directly related to spare_parts, create a measure to retrieve the associated spare parts. Use a Measure Instead of Direct Fields as like below
Eg:
Spare_Part_List =
VAR _SpareParts = CONCATENATEX(
RELATEDTABLE(spare_prts_models),
spare_parts_models[id_spare_part],
", "
)
RETURN _SpareParts
Hope this helps.
Hi rajendraongole1 !
Can I use this measure to correctly display the spare_part field within the table?