The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
92 | |
90 | |
72 | |
69 |
User | Count |
---|---|
231 | |
127 | |
117 | |
82 | |
82 |