Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I can't believe this is even an issue it's bizarre. I want to show a simple count in categories on donut chart involving 2 tables with a direct relaitonship, and I can get the values in a table but only when adding certain columns from both tables and I don't know how to replicate that filter context in the donut chart or why i even need to since the tables are already directly related.
The 2 tables the all awards has only a subset of the ids that are linked on our full ids table vproject. the full table tells me which customer the different projects are with and I only want to see the 33 projects on the awards table and which customers they belong to. instead the filter isn't carrying when I go to the donut chart as it just show the 33 projects belonging to every customer in the database.
any idea how i can force the filter context with dax? I've tried values, calculate but nothing is working so far.
Hello,
One of the possible problems I see is that the relationship is set to "one way only". Maybe changing the relationship type of the link between the tables would work.
Having many-to-many relationships is problematic in general (at least I had some problems with power bi getting lost in them). But if the model are just those 2 tables, I think it is safe to keep it.
Any dimension/measure of either table should work together fine with all that said.
I hope this helps.
Best Regards
Rafael
User | Count |
---|---|
57 | |
21 | |
19 | |
16 | |
16 |
User | Count |
---|---|
87 | |
77 | |
52 | |
37 | |
21 |