Efficient Data Model

[Yrstruly2021]

Please assist in making my data model better to also create usable dax/kpis like churn rate etc?https://drive.google.com/file/d/1s4TjDTbd8gUEqWIJmdG7tpTs-lDEEgcX/view?usp=share_link 

What would you change?

[Greg_Deckler]

@Yrstruly2021 So, in general, avoid bi-directional relationships and try to avoid many-to-many relationships. Your Country Codes need to be cleaned up. The *-* relationship is being caused from what I can see by a few blank rows in your Country Codes table. Clean those up in Power Query. Probably then use that as a bridge table between your Users table and your Paid user count by country... and User county by country. I would also collapse those two tables into a single table. You also need to clean up your Users table. There should only be one row per User in that kind of dimension table. Again, I think this is caused by blank IDs. That should be a start. Hard to really go much deeper until that is all cleaned up.