Hi All,
I've been stuck on the same thing for days now and could do with some help if anyone can!
I am analysing the effect of UK Ofsted Results (Audits) on house prices.
I have 4 tables / queries (which are CSV data and some very large), these are
- OfstedResults - This contains all offsted results for each school over a time frame, within the table / query is a "Result" and "Previous Result" fields, i have also setup a custom column for the "Change Score" which is "Result - Previous Result", also within the table are "PostCode" (equivalent of US Zip Code) and "Year" fields
- PricePaidData - This is a list of all UK house sales over a period of time, like the above table this also has "PostCode" and "Year" fields, and it also has DAX Calculated columns setup in the model to get the average price of houses in a post code / year, the previous years average house price for the post code and the change percentage using these calculated columns.
- PostCode_Lookup - this is a lookup table for all postcodes
- Year_Lookup - this is a lookup table for year (probably not required now)
All relationships are setup correctly
I then have two visualisations,
- Ofsted Results Avg Change Value by Year and PostCode district, this is a matrix, with Rows for PostCode_Lookup[District], Columns for Year_Lookup[Year] and Values of Average of OfstedResults[Change Value]
- House Price Average Change % by Year and PostCode district, this is a matrix, with Rows for PostCode_Lookup[District], Columns for Year_Lookup[Year] and Values of Average of PricePaidData[Change Percentage]
The two visualisations above have correct values showing, but i now need to show this on a scatter plot to show the relationship and no matter what i plug in to the values it doesnt work.
My "dependant" variable would be House Prices and my independant variable would be Ofsted results.
Can anyone shed any light on how to ge this please?
Thanks
Jamie
