Forum Discussion
Solved
Measure with row level calculations
Need help to create measure with row level calculations instead of calculated column. For example: Revenue = Posted Hours * Hourly Rate Tables: Employee table with general informat...
It's hard to say exactly what you need but the general approach would be something along these lines:
Revenue = SUMX ( Transaction, Transaction[Posted Hours] * RELATED ( HourlyRate[Hourly Rate] ) )
It's hard to say exactly what you need but the general approach would be something along these lines:
Revenue =
SUMX (
Transaction,
Transaction[Posted Hours] * RELATED ( HourlyRate[Hourly Rate] )
)
Awesome!! thanks