Forum Discussion
Solved
Need Help: column total
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
,
create a new measure
M2 = SUMX(VALUES(Machine number),[SUM of Total availble hrs])
2 Replies
create a new measure
M2 = SUMX(VALUES(Machine number),[SUM of Total availble hrs])
Thank you. works like a charm.
