Forum Discussion
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.
Hi Dominik_D,
We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.
If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.
Thank you.