Averages

[hughfitz]

Hi all,

Real newbie here, I'm using some census data for analysis in power BI and I'm trying to work out the average income of certain postcodes (Australian). It's in a CSV string value format. 

Here is a list of my data, essentially what I want to calculate is: (Count x average income)/sum of count by PostCode and/or State if that makes sense.

 I've had a play with quick measures etc. but I cant quite get it. 

Thanks! 

[hughfitz]

To add  to the above, the orignal data was broken down into income ranges ($1-$149, $150-$299 etc.) so I averaged out each to become a single value. i.e. in Queensland, at postcode 4670 there were 343 people earnning $349.50, in addition at the same postcode there were 200 people earning $75, 12 earning $1499 etc. 

Sorry to overexplain, but I havent seen a lot of info on data that is shown in string format on the forum

[v-yuezhe-msft · Accepted solution]

@hughfitz,

Please check if the DAX in the PBIX file below returns your expected result.

https://1drv.ms/u/s!AhsotbnGu1Nok1DJUtrfcCk7XQ48

Regards,
Lydia

[hughfitz]

Hi Lydia,

thanks a lot for tat, it did return the expected result! Much appreciated :). 

Hugh