how to use divide and subtract from different tabls

[Anonymous]

hi,

i have two tables where i will be basing my calculation from. i need to get the %Uptime of a specific facility: here is my calculation in excel.

Measure

%uptime = (prod hours - lost hours) / prod hours

Prod hours  is from Production Hours Table

Lost Hours is form Incident Fact Table

How do i calculate it? Thanks for the answers.

[Anonymous]

thanks. i was able to get the measure. 🙂

[amitchandak · Accepted solution]

@Anonymous ,prod hours and  lost hours need to be measures and you can analyze them across common tables

%uptime = Divide(Sum(Production [prod hours] )- Sum(Fact[lost hours]) ,  Sum(Production [prod hours] ))