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 for supply and one for demand.
In the supply sheet the ID is a unique identifier, on the demand side each location can occur several times.
The data sets are connected by two tables, one for geography and one for time. Geography and supply should be connected by an 1:1 relation but I cannot select this.
Please see the reports in the sample file. I can calculate the number of free workstations - using demand and supply datasets - with correct results and also show it in a graph in the third sheet. But as soon as I want to filter the measure "free workstations" by location or department I get wrong values.
Would be great if you have a solution for me
Thanks in advance!