Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |