Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |