Forum Discussion
Divide sums across two tables
Hello, I am trying to create a new measure (or table) to output of the summation of 'Table1 BCM' divided by summation of 'Table2 SMU Hrs' by 'Dig Unit #' type as a filter. I tried using this but ...
amitchandak
Super User
Super Userja342 , what are you trying to filter
FILTER (Table1, Table1[Dig Unit #] )
give some value
FILTER (Table1, Table1[Dig Unit #] = "ABC")
or
FILTER (Table1, Table1[Dig Unit #] = related(Table2[Dig Unit #] ))
I am trying to create a visual table that looks like this:
| Dig Unit # | BCM / hr Day | BCM / hr Night |
| Ex1 | 1,250 | .. |
| Ex2 | 1,230 | .. |
| Ex2 | .. | .. |
The values inside this table is what I am trying to sum from two different tables. The BCM value is in table 1 and Hr values are in table 2. Both of which need to be summed up for this summary table above. I tried merging queries and using relationships neither of which seemed to produce result needed.