Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Max Total

Hi All,   I want to have grand total of Max values   Here is how data set looks like   sometimes i have 2 dates, sometimes 3 dates, but target needs to be same, hence Iam struggling...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    msksenthil 

     

    dont know if this is bloated, i kinda got it working with this

    i forgot about summarise earlier

     

    Measure =
    Var MaxTarget = maxx('Staff Daily Utilisation','Staff Daily Utilisation'[Target Max As per current working Days])
    Var MaxTargetTotal = SUMMARIZE('Staff Daily Utilisation','Staff Daily Utilisation'[Staff Name],"Max Total",MaxTarget)
    Return
    if(HASONEVALUE('Staff Daily Utilisation'[Staff Name]),
    MaxTarget,
    SUMX(MaxTargetTotal,[Max Total]))
msksenthil's avatar
msksenthil
Helper III
5 years ago

@luisClive Thanks,

I believe you have many fields with different values on each record, in this case, we have calculated by not considering the other fields except the required fields like 'date' & 'Target Hours'

SUMX (
SUMMARIZE ( Maxhours, Maxhours[Date], "Hours", MAX ( Maxhours[Target hours] ) ),
[Hours]
)

Hope this helps,

MS

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    msksenthil tnks let me try Summarize function, let me check it out

    FrankAT thanks, i havent used inscope before, i check this too