Measure using 2 different tables, filtered by calendar table.

[MattScruggs]

I have a measure that I am trying to build that will calculate A/B for each line in 2 different tables

for example: 

50/5 = 10 

where 50 is 'Table 1'[Feet]

and 5 is 'Table 2'[Hours]

either or both can potentially be 0. 

I tried F/H = SUM('Table 1'[Feet])/SUM('Table 2'[Hours]), Which theoretically works, until I try to I put it on a bar graph with Month as the axis. It show data for every month on Table 1, even though Table 2 only has three months entered. 

I need to be able to break this up by Project, Site, and Step. Both tables have these as columns. 

[amitchandak]

@MattScruggs , Unles Table 1 and Table2 are in 1-M or M-1 relation. You should create a common date and other dimesion tables and analyze using those common tables.

Change you formula like

F/H = divide(SUM('Table 1'[Feet]),SUM('Table 2'[Hours]))

Refer:https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

https://www.seerinteractive.com/blog/join-many-many-power-bi/

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.