Forum Discussion
Measure using 2 different tables, filtered by calendar table.
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.
1 Reply
- amitchandak
Super User
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.
