Forum Discussion

AllG's avatar
AllG
Frequent Visitor
5 years ago
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:

 

  1. Employee table with general information about employees (Emp ID, Name, BU, Leader, Manager, CC ect.)
  2. Transaction table with posted hours (Emp ID, Posted Hours, Transaction Date)
  3. Hourly Rate table (Emp ID and Hourly Rate)

 

Relationships:

Employee[Emp ID] : Transaction[Emp ID]

Employee[Emp ID] : Hourly Rate[Emp ID]

 

Summary required: Revenue by Leaders, Managers and BU by Months (matrix, like pivot table)

Need Help
  • AlexisOlson's avatar
    AlexisOlson
    5 years ago

    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] )
)

     

2 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    5 years ago

    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] )
)