Data Model

[mohammedkhan]

Dear Concern,

I would like to know where did i do wrong in the data model, need help 

mentione belowis the measure i created 

/*

Pop in 2017 = CALCULATE(SUMX('All States Population', 'All States Population'[Population]), FILTER('All States Population', 'All States Population'[Years] = 2017))

*/

Data ModelDue to Data Model

[jdbuchanan71]

@mohammedkhan 

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.

https://www.sqlbi.com/p/introducing-dax-video-course/

[kentyler]

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