Need Help: column total

[PatrickWong]

I have 2 table set which is related by the date. in first table, it is just the date and hour available for that date (range). on the second table, I have machine and how much time is used on the machine. when I visualise the 2 table together, I am not able to get the total correct

, 

[Ahmedx · Accepted solution]

create a new measure

M2 =  SUMX(VALUES(Machine number),[SUM of Total availble hrs])

[PatrickWong]

Thank you. works like a charm.