Hi!
I have 3 tables (Datasets) as the ones on the top (A, B and C).
And I created a Visualization Table in PBA as the one on the left corner.
How can I create the orange Visualization Table needed?
Hi @Anonymous,
You have a problem in your data. I assume you have built your VISUALIZATION TABLE using the many-to-many relationship between the Table A and Table B. But if you take a close look at Shelly from Marketing in the Table A, you will see that there are two entries in the Table B which can be applied to her: Manager-Marketing and Relationships-Marketing.
You can close your eyes, ignore this duality and solve your case with the crazy measure below, but I won't recommend doing that - it would be better to double check your data model.
Best Regards,
Alexander
Hi @Anonymous,
You have a problem in your data. I assume you have built your VISUALIZATION TABLE using the many-to-many relationship between the Table A and Table B. But if you take a close look at Shelly from Marketing in the Table A, you will see that there are two entries in the Table B which can be applied to her: Manager-Marketing and Relationships-Marketing.
You can close your eyes, ignore this duality and solve your case with the crazy measure below, but I won't recommend doing that - it would be better to double check your data model.
Best Regards,
Alexander
Helpful resources
Power BI Monthly Update - March 2025
Check out the March 2025 Power BI update to learn about new features.
Fabric Community Update - March 2025
Find out what's new and trending in the Fabric community.
