Utilization/ Occupancy (percentage over time) for different charging stations

[Anonymous]

Lets say, I have data with different charge stations used for last 60 days with start time and end time. I also created two calculated tables "DimDate" with dates, week, day and another table "time" which has two columns "time start" and "time end" to make 1 hour time interval each row. How to proceed with these to find utilization of different stations (percentage over time). Kindly help!

[Anonymous]

For instance, it is the dataset (sample). The charge port id column has same id several times used in last 60 days. I want to find the occupancy (percentage over time) where y axis will show percentage of occupancy and x axis different charge ids in the line chart. 

I have created "time" table which shows all time hourly intervals

Another table "CharginDataReshaped" was created which contains rows for each charge Id & hourly interval during which that charge id is active. When I create a measure called

Occupancy = DISTINCTCOUNT(CharginDataReshaped[ChargePoint ID]). The line chart gives me a nice curve with %occupancy, time but no information when I choose charge id (it shows 100% occupancy for any id). How can I change it so I get different percentage of occupancy for different charge ids

[FreemanZ]

hi @Anonymous 

try to bring more context, e.g. is %occupancy a measure? You mentioned three tables, how are they related?

[Anonymous]

Yes, Occupancy is measure. Our main dataset is charging data (first one). I created next two tables to make a modified table with hourly interval on specific dates during which charge ids were active. Let me know if you have any alternative way? Thanks

[FreemanZ]

hi @Anonymous 

it would be easier for all, if you could also post some sample data.