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
Dear Concern,
I would like to know where did i do wrong in the data model, need help
mentione belowis the measure i created
/*
*/
All of your relationships are many to many bi-directional which is a nightmare to trouble shoot. You should probably start with an into to DAX and modeling. I suggest this one as it is free but also very good.
For a start could you combine your income and population tables into just one fact table ? Do the "united states" and "all states" tables have different data for the same state and year. If not you could combine then. Then you would not need the many/many relationship to dates.
and that might make all your calculations work out more easily
Help when you know. Ask when you don't!
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 |
---|---|
105 | |
100 | |
81 | |
62 | |
54 |
User | Count |
---|---|
249 | |
119 | |
115 | |
94 | |
70 |