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

Anonymous  can you try the below


SUMX ( DISTINCT ( 'TableName' ), 'TableName'[FieldName] )
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    msksenthil 

    tnks

    I have tried this before,  since all values are distinct, just that some data is missing everyday and i want to put max regardless