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 - April 2025
Check out the April 2025 Power BI update to learn about new features.
NEW! Community Notebooks Gallery
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Fabric Community Update - April 2025
Find out what's new and trending in the Fabric community.
