Please help with Wrong total

Question

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 ?&nbsp;&nbsp;VAR Min_Date = MIN('Calendar Service'[YearMonth])
VAR Max_Date = MAX('Calendar Service'[YearMonth])
VAR _gp = MAX('Group Dim'[GP])

VAR _ACTIVE_ID = GROUPBY(FILTER(‘Table’,([ENR_DT]&gt;= Min_Date &amp;&amp; [ENR_DT]&lt;= Max_Date) &amp;&amp; ([ENGAGED_DT]&gt;= Min_Date &amp;&amp; [ENGAGED_DT]&lt;= Max_Date) &amp;&amp; ‘Table’[GP]=_gp &amp;&amp; [ID] &lt;&gt; "0" ),’Table’[ID])

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

VAR _TempUnion= 
CALCULATETABLE(
GROUPBY(
SUMMARIZE(FILTER(‘Table’, ‘Table’[ID] IN _ACTIVE_ID &amp;&amp; ([ENR_DT]&gt;= Min_Date &amp;&amp; [ENR_DT]&lt;= Max_Date) &amp;&amp; ([ENGAGED_DT]&gt;= Min_Date &amp;&amp; [ENGAGED_DT]&lt;= Max_Date) &amp;&amp; ‘Table’[GP]=_gp), [ID],  "_DEN", 0, "_NUM", 0, "_MBR_MOS", CALCULATE(SUMX(‘Table’,[MOS]),’Table’[ENG_Date] = _MIN_ENG_DT)) [ID] , "_MOS",  SUMX(CURRENTGROUP(),[MOS])))
    
RETURN 
CALCULATE(SUMX(_TempUnion,[MOS]))&nbsp;&nbsp;&nbsp;wront total:&nbsp;

greg_deckler · Answer

NilR&nbsp;First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742eThis looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907Also: https://youtu.be/uXRriTN0cfYAnd: https://youtu.be/n4TYhF2ARe8

greg_deckler · Answer

NilR&nbsp;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 · Answer

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

nilr · Answer

I figured this is wrong:VAR _MIN_ENG_DT= CALCULATE(MINX( SUMMARIZE(FILTER(‘Table’,([ENR_DT]&gt;= Min_Date &amp;&amp; [ENR_DT]&lt;= Max_Date) &amp;&amp; ([ENGAGED_DT]&gt;= Min_Date &amp;&amp; [ENGAGED_DT]&lt;= Max_Date) &amp;&amp;’Table’[GP]=_gp &amp;&amp; [ID] &lt;&gt; "0" ), ‘Table’[ID],"_Min", Min(‘Table’[ENG_Date])),[_Min]))

parry2k · Answer

NilR&nbsp;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.
&nbsp;
&nbsp;

Forum Discussion

Please help with Wrong total

7 Replies

Related content

Wrong Total

Wrong Total in Table

Wrong total

Total measures show wrong total when report is published

wrong total