Forum Discussion

PowerPaul's avatar
PowerPaul
Helper I
3 years ago
Solved

Help w SumX using calculated column (multiplication)

Hi all I have a data model which Im using to calculate costs in an excel data model. Each employee is assigned a % they are on a scrum team. I have the daily rate for each employee and multiply that...
data model issue
DAX
Excel
Sumx()
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi PowerPaul 

    please try

    AdjDailyRate:=SUMX(Scrum__W_Rates,Scrum__Rates[Adjusted Daily Rate])

    however, the normal sum should also work. What do you have on the rows of the pivot table?

PowerPaul's avatar
PowerPaul
Helper I
3 years ago

Hi tamerj1, the regular sum has worked. I am not sure why it didnt work the last time maybe because I used calculate(sum but with no filters it should have been the same. 

I find Excel to be very buggy and always has issues so maybe there is something wrong w my version of excel. 

My pivot table rows consist of scrum team name followed by employee name. 

This gives me the view of each scrum team members, the % and cost per team. 

I appreciate the help. 

Thanks

tamerj1's avatar
tamerj1
Community Champion
3 years ago

PowerPaul 
I don't work so often with Power Pivot but it does behave differently compared to Power Bi that is true.