Forum Discussion

sandrasamoah's avatar
sandrasamoah
New Member
9 years ago
Solved

Visual for Difference between Profit and cost

Data table 1                       Calculated column   Person Product Number Job Title Hours Rates Cost   Sandra KICK 1 Managing Partner 50 100 5000   Priscilla...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    Relate the two tables on Person or you may need a Person bridge table with unique values and relate both tables to it. You should then be able to create a measure like:

     

    RevenueCost = [Revenue KPI] - SUM(RELATED(Table1[Cost]))
Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

Relate the two tables on Person or you may need a Person bridge table with unique values and relate both tables to it. You should then be able to create a measure like:

 

RevenueCost = [Revenue KPI] - SUM(RELATED(Table1[Cost]))
sandrasamoah's avatar
sandrasamoah
New Member
9 years ago

Thanks, I am grateful. I had been grappling with this for a while.