cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
beasta
Frequent Visitor

Market value weighted construction year

I already searched the forum and couldn't not find the solution so far. I created a measure for the market vlaue weighted construction year of a real estate portfolio. This works fine as long as I select the whole portfolio or a single property but as soon as I have two properties it doesn't work anymore. This is because of the market value weightings (MV%) which is based on the whole portfolio but how can I make the MV% dynamic? What I mean, if I for e.g. select the canton VD (5 properties) the weighted construction year is 281 instead of  1984.

 

many thanks for your help! (how can I upload an example of the measures I did?)

1 ACCEPTED SOLUTION
v-gizhi-msft
Community Support
Community Support

Hi,

 

Please change your original [MV_tot] to this:

MV_tot = CALCULATE(SUM(Sheet1[Market Value]), ALLEXCEPT(Sheet1,Sheet1[Cantone])) 

The result shows:

6.PNG

See the attached pbix file.

 

Best Regards,

Giotto

View solution in original post

4 REPLIES 4
v-gizhi-msft
Community Support
Community Support

Hi,

 

Please change your original [MV_tot] to this:

MV_tot = CALCULATE(SUM(Sheet1[Market Value]), ALLEXCEPT(Sheet1,Sheet1[Cantone])) 

The result shows:

6.PNG

See the attached pbix file.

 

Best Regards,

Giotto

View solution in original post

Many thanks for your reply and sorry for my late response, I was on vacation. 

This actually only solves part of the problem. When you deselect VD, you get a weighted Construction Year of 15697 which is certainly not correct. I'm looking for a solution, where the weightings adapts itself depending on the selection, no matter whether it's the canton, the location or rental income. Isn't there a way to have the weightings dynamically depending on the selection/filter?

parry2k
Super User III
Super User III

@beasta share sample data with expected output, you can share using onedrive/google drive Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





beasta
Frequent Visitor

I hope this Link works

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.