Total not working

GM17 — Wed, 20 Sep 2017 06:56:06 GMT

Hi All,

I measure column below in a table-

IF(ISBLANK(CALCULATE(DISTINCTCOUNT(VW_PRS_LCS_Activity[LCSACT_ActID]),FILTER(VW_PRS_LCS_Activity,(VW_PRS_LCS_Activity[LCSACT_ActName] <> "Development Work" && VW_PRS_LCS_Activity[LCSACT_ActPastDue]>0)))),0,CALCULATE(DISTINCTCOUNT(VW_PRS_LCS_Activity[LCSACT_ActID]),FILTER(VW_PRS_LCS_Activity,(VW_PRS_LCS_Activity[LCSACT_ActName] <> "Development Work" && VW_PRS_LCS_Activity[LCSACT_ActPastDue]>0))))

The details row in the table gives the correct result while Total is not returining the correct value? Please suggest the way so that total returns the correct value.

Re: Total not working

Eric_Zhang — Thu, 21 Sep 2017 07:15:30 GMT

@GM17 wrote:

Hi All,

I measure column below in a table-

IF(ISBLANK(CALCULATE(DISTINCTCOUNT(VW_PRS_LCS_Activity[LCSACT_ActID]),FILTER(VW_PRS_LCS_Activity,(VW_PRS_LCS_Activity[LCSACT_ActName] <> "Development Work" && VW_PRS_LCS_Activity[LCSACT_ActPastDue]>0)))),0,CALCULATE(DISTINCTCOUNT(VW_PRS_LCS_Activity[LCSACT_ActID]),FILTER(VW_PRS_LCS_Activity,(VW_PRS_LCS_Activity[LCSACT_ActName] <> "Development Work" && VW_PRS_LCS_Activity[LCSACT_ActPastDue]>0))))

The details row in the table gives the correct result while Total is not returining the correct value? Please suggest the way so that total returns the correct value.

@GM17

I don't find something wrong with that measure. As to the incorrect Total, could you post any sample data and snapshots? By the way, for better readability, the measure can be

your measure =
VAR value =
    CALCULATE (
        DISTINCTCOUNT ( VW_PRS_LCS_Activity[LCSACT_ActID] ),
        FILTER (
            VW_PRS_LCS_Activity,
            ( VW_PRS_LCS_Activity[LCSACT_ActName] <> "Development Work"
                && VW_PRS_LCS_Activity[LCSACT_ActPastDue] > 0 )
        )
    )
RETURN
    IF ( ISBLANK ( value ), 0, value )

topic Re: Total not working in Developer

Total not working

Re: Total not working