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!
Fabric Community Update - November 2024
Find out what's new and trending in the Fabric Community.
We want your feedback!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
| User | Count |
|---|---|
| 90 | |
| 89 | |
| 85 | |
| 73 | |
| 49 |
