Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dsitribute time spent based on categories

So I have a table that is structured as follows :   Customer Category Time Summary Cust A Cat1 3 Something Cust B Cat2 1 Something Cust A Cat 2 2 Something All Cust Cat1...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

We can get the time spent per categories by the following measure.

 

Measure = CALCULATE(SUM(Table1[Time]),ALL(Table1),VALUES(Table1[Category]))

 

 

Please check the pbix as attached. If I misunderstand you, please share your excepted result to me.

 

Regards,

Frank

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,  So it isn't exactly what I need, what I want is for the "All Cust" time to be distributed to the SUM of time of EACH other customer based on the category so that at the end I have something like this : 
    All Cust Cat1 Time = 2
    ALL CustA Cat1 time = 3+((All Cust Cat1 Time)/(Number Of Cust)) which here = 3+1 = 4
    ALL CustB Cat1 time = 0+((All Cust Cat1 Time)/(Number Of Cust)) which here = 0+1 = 1
    ALL CustB Cat2 time = 1+((All Cust Cat2 Time)/(Number Of Cust)) which here = 1+0 = 0

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Still searching for a way to do it ... I've found a way to sum it and distribute it WITHOUT keeping the category or to sum the category but WITHOUT being able to distribute it ...