Forum Discussion
Averages
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,
Please check if the DAX in the PBIX file below returns your expected result.
https://1drv.ms/u/s!AhsotbnGu1Nok1DJUtrfcCk7XQ48
Regards,
Lydia
3 Replies
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
hughfitz,
Please check if the DAX in the PBIX file below returns your expected result.
https://1drv.ms/u/s!AhsotbnGu1Nok1DJUtrfcCk7XQ48
Regards,
LydiaHi Lydia,
thanks a lot for tat, it did return the expected result! Much appreciated :).
Hugh
