Power BI shows wrong data

Thankyou, amitchandak , danextian, for your response.

Hi Dominik_D,

We appreciate your inquiry on the Microsoft Fabric Community Forum.

Based on my understanding, when you add the Architect and Elektroplaner fields directly to your table visual in Power BI, it results in multiple rows per quote for each unique combination of those fields. Consequently, this may create the appearance of duplicate quotes.

Please follow the steps outlined below, which may help resolve the issue:

1.Use DAX measures to aggregate the Architect and Elektroplaner names:

Architect List = CONCATENATEX(VALUES('ArchitectTable'[ArchitectName]), 'ArchitectTable'[ArchitectName], ", ")
Elektroplaner List = CONCATENATEX(VALUES('ElektroplanerTable'[ElektroplanerName]), 'ElektroplanerTable'[ElektroplanerName], ", ")

 
2.Use these measures in your table instead of the raw fields. By doing so, each quote will appear only once while still displaying all related names in a comma-separated format. Alternatively, you may consider using a Matrix visual or restructuring the model to further reduce duplication.

Additionally, please refer to the following link for guidance:
Model relationships in Power BI Desktop - Power BI | Microsoft Learn

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

Thank you.