Forum Discussion

SoulCuber's avatar
SoulCuber
Frequent Visitor
10 years ago
Solved

Calculate column with subtotals

I would like to create a column/measure that computes the sum of one column for all distinct combinations of two other columns.   The example below shows hours per operator per date. The last colum...
Need Help
  • Vvelarde's avatar
    Vvelarde
    10 years ago

    hello SoulCuber

     

    This give you the solution

     

    Job Hours = CALCULATE(Sum(Table1[Hours]),ALLEXCEPT(Table1,Table1[Date],Table1[Job]))

     

    =)

madhuradighe's avatar
madhuradighe
Regular Visitor
8 years ago

Dears,

I'm stuck in getting below calculation; any help is much appreciated :)

I want to divide column C each row by the subtotal of column D

 

Cheers! MD