Forum Discussion
Solved
Aggregation over facility
See sample below. I have a table with data from different facilities. These facilities have multiple "production tables" and they also have special equipments (water pumps) with a defined gallons cap...
Hi lg01 ,
You can achieve your goal by this DAX calculated column:
Capacity Per Facility (gal) = CALCULATE ( SUMX ( VALUES ( 'Sample Table'[water_pump_id] ), FIRSTNONBLANK ( 'Sample Table'[water_pump_capacity (gal)], 0 ) ), ALLEXCEPT ( 'Sample Table', 'Sample Table'[facility_id] ) )Now your table will look like this:
Thank you for all your replies and the effort. Much appreciated.