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 @geronimoagosti,
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 @geronimoagosti,
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
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Fabric Community Update - January 2025
Find out what's new and trending in the Fabric community.
| User | Count |
|---|---|
| 144 | |
| 87 | |
| 65 | |
| 50 | |
| 45 |
