Forum Discussion
Solved
Average Measure : matrix row and sub row calculation
Hi I have a table which lists Vehicle Type, Vehicle Id, Date, Journey Id and Journey Duration. Each Vehicle Id completes multiple journeys across multiple dates. ...
looks like I've now solved this using.....
Measure =var _tbl1 = SUMMARIZE(Vehicle_Journey, Vehicle_Journey[vehicleId], Vehicle_Journey[StartDate],"a",sum(Vehicle_Journey[Journey Duration]))var _average = averagex(_tbl1,[a])return _averagehave spent a whole day battling with this and then work it out within a few minutes of posting for help 🙄!
