Measure to use in a SCD type 2

[NunoTrigo1986]

Taken the following sample of my database:

In tihs sample there is 3 different entries. Each entry is defined mainly by the adress. Here we track  rent announces. As we can see each announce can have different entries that are stampled by "date from" and "date to". Usually the difference between entries of same house is the price. Some housing rentals are inactive (not shown in the sample), and so under column "iscurrent" it is a 0 (incative) and not (1) active.

I need to have three measures that I am struggling quite hard to get:

-A measure that gives the average of last active announce per house?The measure should take into account active announces or the latest inactive account (the last one). ANother measure should just have in account inactive announces (iscurrent 0).

- usually when there is several entries for each announce, it is because home owner is changing the rental price. I would like to get an line graf with average og price changing between the first announce of an house and the last one. It can be aggregated ( it means all), or specified by city or indicidually ( the last filters is easy to do if i set a filter.

Thanks for your help. 

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523