SUMX not totaling correctly! PLEASE HELP

Hi,

I am not sure how your semantic model looks like, but please try something like below whether it works.

My Measure =
SUMX (
    VALUES ( Dates[Month] ),
    CALCULATE (
        IF (
            NOT ( ISBLANK ( [Total Hours Worked] ) ),
            DISTINCTCOUNTNOBLANK ( Logics[BBS] ),
            0
        )
    )
)

Hi HALEYSTODDARD ,

You can create a new measure as below based on the existing [BBS Rate], then put this new measure onto the visual to replace the measure [BS Rate]:

BBS Rate =
IF (
    NOT ( ISBLANK ( [Total Hours Worked] ) ),
    DISTINCTCOUNTNOBLANK ( Logics[BBS] ),
    0
)

New measure = SUMX ( VALUES ( Dates[Month] ), [BBS Rate] )

In addition, you can refer the following links to try to solve your problem...

Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand

Dax for Power BI: Fixing Incorrect Measure Totals

Best Regards

Hello HALEYSTODDARD ,

You need to modify your dax a bit to solve this issue :

My Measure =
SUMX(
VALUES(Dates[Month]),
VAR _HoursWorked = [Total Hours Worked]
RETURN
IF(
NOT(ISBLANK(_HoursWorked)),
DISTINCTCOUNTNOBLANK(Logics[BBS]),
0
)
)

Alternatively you can try forcing explicit aggregation if above is not working :

My Measure =
SUMX(
SUMMARIZE(
Dates,
Dates[Month],
"@DistinctCount", DISTINCTCOUNTNOBLANK(Logics[BBS])
),
[@DistinctCount]
)

I hope this helps.

Did I answer your query ? Mark this as solution if this helps, Kudos are appreciated.

Warm Regards,

Neeraj