Total is wrong

Question

Hi all,&nbsp;&nbsp;I have created an measure to calculate the headcount monthly based on data range criterias, for each month the result is correct. However when I display the figures in a table split by month the total is wrong.&nbsp;&nbsp;The return from PBI&nbsp;&nbsp;MonthHC_monthjan505fev505mar498abr519mai515jun516jul521ago534set559out555nov568dez565TOTAL5919&nbsp;The right amount for the total should be&nbsp;&nbsp;MonthHC_monthjan505fev505mar498abr519mai515jun516jul521ago534set559out555nov568dez565TOTAL6360&nbsp;&nbsp;That's my measure code&nbsp;&nbsp;HC_MONTH = COUNTROWS(
                         FILTER(Payroll,
                                 (Payroll[Payroll nb]&lt;&gt;376)&amp;&amp; (Payroll[Payroll nb]&lt;&gt;377)&amp;&amp; (Payroll[Payroll nb]&lt;&gt;445) //exclude 3 specifics employees Expat
                                 &amp;&amp;'Payroll'[Most Recent Hire Date] &lt;= MAX (Calendar[Date])
                                 &amp;&amp; (ISBLANK ('Payroll'[Administrative End Date]) || 'Payroll'[Administrative End Date] &gt;= MAX (Calendar[Date]))
                               )
                    )&nbsp;Any thought that what is wrong on my measure code, or how can I improve it ?&nbsp;&nbsp;I have attached an example of the worksheet that is feeding my database on PowerBI.&nbsp;Example

themistoklis · Accepted Answer

Anonymous&nbsp;Change your formula to this one:&nbsp;HC_MONTH =
SUMX (
    VALUES ( 'Calendar'[Month Name] ),
    CALCULATE (
        COUNTROWS (
            FILTER (
                Payroll,
                ( Payroll[Payroll nb] &lt;&gt; 376 )
                    &amp;&amp; ( Payroll[Payroll nb] &lt;&gt; 377 )
                    &amp;&amp; ( Payroll[Payroll nb] &lt;&gt; 445 ) //exclude 3 specifics employees Expat
                    &amp;&amp; 'Payroll'[Most Recent Hire Date] &lt;= MAX ( Calendar[Date] )
                    &amp;&amp; (
                        ISBLANK ( 'Payroll'[Administrative End Date] )
                            || 'Payroll'[Administrative End Date] &gt;= MAX ( Calendar[Date] )
                    )
            )
        )
    )
)

Forum Discussion

Total is wrong

2 Replies

Related content

Wrong Total

Wrong Total in Table

Wrong total

wrong total

Wrong total in list

Month	HC_month
jan	505
fev	505
mar	498
abr	519
mai	515
jun	516
jul	521
ago	534
set	559
out	555
nov	568
dez	565
TOTAL	5919