Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
@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.
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |