Forum Discussion

cheid_4838's avatar
cheid_4838
Helper IV
11 months ago
Solved

Grand Total Not Summing Correctly

I am trying to calculate % of Lines Per Week, but I am having trouble getting the Line Count Per Week to sum to 2,355 when I roll the total up to one line.  I get the correct percentages when go down...
Need Help
  • mh2587's avatar
    mh2587
    11 months ago
    % of Lines Per Week = //Try this might help you
DIVIDE (
    SUMX (
        SUMMARIZE (
            STOPS,
            STOPS[Start of Week],
            STOPS[Facility],
            "Stops", SUM ( STOPS[Total Stops] )
        ),
        [Stops]
    ),
    CALCULATE (
        SUMX (
            SUMMARIZE (
                STOPS,
                STOPS[Start of Week],
                STOPS[Facility],
                "Stops", SUM ( STOPS[Total Stops] )
            ),
            [Stops]
        ),
        REMOVEFILTERS ( STOPS )
    )
)
mh2587's avatar
mh2587
Super User
11 months ago
% of Lines Per Week = //Try this might help you
DIVIDE (
    SUMX (
        SUMMARIZE (
            STOPS,
            STOPS[Start of Week],
            STOPS[Facility],
            "Stops", SUM ( STOPS[Total Stops] )
        ),
        [Stops]
    ),
    CALCULATE (
        SUMX (
            SUMMARIZE (
                STOPS,
                STOPS[Start of Week],
                STOPS[Facility],
                "Stops", SUM ( STOPS[Total Stops] )
            ),
            [Stops]
        ),
        REMOVEFILTERS ( STOPS )
    )
)