Incorrect Sum of Rows

Hi  Anonymous ,

According to your description, the problem may be caused by the wrong statistics of the formula. If you want the value of Fiscal Month + Fiscal Date, where the Fiscal Month field counts the number of individuals, then you can refer to a formula similar to the following.

Column =
COUNTROWS ( 'Table' )
    + CALCULATE (
        SUM ( 'Table'[Headcount] ),
        ALLEXCEPT ( 'Table', 'Table'[Fiscal Date].[Month] )
    )

If the problem is still not resolved, can you provide the relevant test data (remove sensitive information) to facilitate me to answer for you as soon as possible. Looking forward to your feedback.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.