count is not surfacing relationship in pie chart

[Mmahachi]

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. 

donut going nuts and table showing correctly numbers

[rafaelcostatl]

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