PowerBI Relationship - missing groups by user by country

Job ID: 31663206

Budget: €8 – €30 EUR

Hello all,

(skills: PowerBI, PowerQuery, SQL, M code, DAX)

I have 2 tables:
User table and Groups that every user should have Table

I need to retrieve table with all missing groups by user by country

then I need measure: the count of users who are missing groups
and visual: stacked bar - count of users with missing groups vs. with correct groups by country

Please review pbix file and excel file attached and then apply please.

If the project will be ready in 1 hour - there is a bonus!
Related categories: Excel SQL Power BI