calculate utilization from 2 tables related one-to-many

[linkrrf]

Hi im new here. what is wrong with my measure? i want to calculate percent utilization. just divide the two column and i would like also that it will work at any given time frame.. This is my relationship

so basicall my fact table have [date] [machine] [totaleggset] and the second table [machine] and [capacity] both are related one-to-many by [machine]

,

[Anonymous]

Hi @linkrrf ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[linkrrf]

Thank you for seeing my problem. Im sorry this is my very first post here. what i want as a result would be like this. 

a percent utilization per row. but when group by month for example, it would total all total egg set for the month also the corresponding capacity and divide them both

the location of total egg set is on the fact table, HEset.

i hope my explaination is clear

[linkrrf]

i dont know why but my measure [utilization] was aggregated by sum. im hoping for the result would be 15345/15840 = 96.9% and so on. and hopefully the measure will work with a given time frame. i will later insert slicer of date.