Forum Discussion

SkorpionAAM's avatar
SkorpionAAM
Icon for Helper V rankHelper V
4 years ago
Solved

Need maxx

I have function i need to add max date in this function i tried but getting error     UNQExpected = sumx(Summarize('mms Statistics', 'mms Statistics'[run_name_segement] ,'mms Statistics'[layernam...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi SkorpionAAM ,

     

    If you want to get the maximum [Expected] of each 'mms Statistics (2)'[run_name_segement])  and  'mms Statistics (2)'[layername] ? If so , please try:

    MAXX = MAXX(FILTER(ALL('mms Statistics (2)'),[run_name_segement] =MAX('mms Statistics (2)'[run_name_segement]) && [layername] =MAX('mms Statistics (2)'[layername])),[Expected])

     

    If not,  can you please share more detail information about the logic of MAX  to help us clarify your scenario?
     
     
    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SkorpionAAM's avatar
SkorpionAAM
Icon for Helper V rankHelper V
4 years ago

any luck ???

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Sorry but which unique value do you wish to calculate and what visual are you placing it in? Please provide a depiction of the visual

    At a guess: