Forum Discussion

NilR's avatar
NilR
Icon for Post Patron rankPost Patron
3 years ago

Please help with Wrong total

As you see in the first table I need to only include the Min([Engagement_Date]) , I did it but my total keep coming back wrong and istead of 88, it shows 16 in my dashboard. can you help ?     VA...
Need Help
Tips and Tricks
NilR's avatar
NilR
Icon for Post Patron rankPost Patron
3 years ago

Thanks Greg_Deckler ! I tried your solution before, but I could not get it working 😞

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

NilR Well, it's a pretty complex measure but maybe try this:

Measure Total = 
  VAR __Table = 
    ADDCOLUMNS(
      SUMMARIZE('Table', [ID], [ENGAGED_DT]),
      "__Value", [Current Measure]
    )
  VAR __Result = IF( HASONEVALUE('Table'[ID]), [Current Measure], SUMX(__Table, [__Value]))
RETURN
  __Result
  • NilR's avatar
    NilR
    Icon for Post Patron rankPost Patron
    3 years ago

    I figured this is wrong:

    VAR _MIN_ENG_DT= CALCULATE(MINX( SUMMARIZE(FILTER(‘Table’,([ENR_DT]>= Min_Date && [ENR_DT]<= Max_Date) && ([ENGAGED_DT]>= Min_Date && [ENGAGED_DT]<= Max_Date) &&’Table’[GP]=_gp && [ID] <> "0" ), ‘Table’[ID],"_Min", Min(‘Table’[ENG_Date])),[_Min]))