Forum Discussion

helpdesk22's avatar
helpdesk22
New Member
3 years ago

Real Estate Data - Filter by Time and Location

Hello everybody, I want to set up a report for occupancy tracking in real estate. Here ist the sample Power BI file: https://we.tl/t-EFqvZbbnlW   There are two data sets in the sample file, one fo...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

 

Geography and supply should be connected by an 1:1 relation but I cannot select this.

 

Your supply table also contains the year. Your data model is correct as it is.

Note the blue i  warning.

 

You could change the measure to 

free workstations = max(0,sum(supply[workstations])-sum(demand[pax]))

 

 

  • helpdesk22's avatar
    helpdesk22
    New Member
    3 years ago

    Thank you very much for your advice!

     

    Now I understand that the tree map only shows positive values.

     

    So what I did now is to create two measures one for missing workspaces and one for free workspaces. I did not use the max function because then the negative values are cut although they are needed in the model.

     

    There was an additional mistake. In the first version of the model the treemap charts did not make use of the geography table.

     

    Obviously you always have to use the help tables for time and geography, otherwise you will receive wrong results.

     

    You find the corrected model here: https://we.tl/t-Tdhqu97j7d