Forum Discussion
Question about DAX Measurements
So I am working on creating an efficiency metric between 2 different reports. The first report will be displaying the amount of miles a car has driven. And then I currently have a report which is dis...
amitchandak
Super User
Super UserAnonymous , You need to have a common dimension between two tables, like person time. Then you can sum(Table1[Mile]) and divide it sum(Table2[Time in hour])
Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19