Measure to calculaute GDP per capita per year per state

[gedwards1988]

Good evening all

My data is structured as follows:

Year       State     Population     GDP

1997       AZ          10000            23497829

1997       AL           96050           35873809

So each state has a year, population and gdp.  How would I create a measure or any othe rmeans other than calculated column to calculate gdp per capita per state per year.

kind regards

[CNENFRNL · Accepted solution]

Hi, @gedwards1988 , you might want to refer to the attached file for calculation,

[gedwards1988]

Also accepted as a solution!!!

[AlB]

Hi @gedwards1988 

1. Place state and year in a table visual

2. Create this measure and place it in the visual:

GDPperCapita =
DIVIDE ( SELECTEDVALUE ( Table1[GDP] ), SELECTEDVALUE ( Table1[Population] ) )

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers