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
parry2k's avatar
parry2k
Icon for Super User rankSuper User
3 years ago

NilR for highlighted rows for id #6, how do you end up getting value 8? There are three rows with the same date, why would you pick 8 and not the other two values? What is the logic? There is no explanation when there is a tie.

 

 

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

parry2k I use below variable to get the Min of date for each ID.

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]))

 I realized it is not working properly and this is the reason that returns wrong total!