Unable to include field values from start schema tables into a single table visual

Thankyou, Uzi2019, for your response.

Hi msksenthil,

We appreciate your inquiry posted on the Microsoft Fabric Community Forum.

Based on my understanding, the error arises because your model contains one-to-many relationships from Table1 to Table2 and Table1 to Table3. When you pull fields from these tables into the same visual without aggregating them, it creates ambiguity in the row context. Since Table3 has multiple status entries per AID, and Table2 has multiple activity dates, Power BI faces difficulty in determining which specific status or date to display for each person.

Please find attached the screenshot and the PBIX file, which might assist you in resolving this issue:

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will benefit other community members encountering similar issues.

Thank you.