Measure not working when totals are enabled in table visual

[BharathM]

Hi Everyone
Measure=

 VAR __Pod = DISTINCT('All Data (2)'[NavSalesFuels.CustomerPod])

  VAR __Date = max('All Data (2)'[ShiftDate])

  VAR __MinDate = EDATE(__Date,-12)

  VAR __Table =

            FILTER(

                All('All Data (2)'),

                        'All Data (2)'[NavSalesFuels.CustomerPod] =

                          __Pod &&

                        'All Data (2)'[ShiftDate] >= __MinDate &&

                        'All Data (2)'[ShiftDate] <= __Date &&

                        'All Data (2)'[True Zero Count] = 1)

  VAR __Result =  COUNTROWS(SUMMARIZE(__Table,'All Data (2)'[ShiftDate]))

RETURN

  __Result


The above measure is working fine values of it are correct only. but when i'm enabling totals in the table visual i'm

 getting error message as below

Thanks in Advance

[tamerj1]

Hi @BharathM 
Please try

Measure1 =
VAR __Date =
    MAX ( 'All Data (2)'[ShiftDate] )
VAR __MinDate =
    EDATE ( __Date, -12 )
VAR __Table =
    FILTER (
        CALCULATETABLE (
            'All Data (2)',
            ALL ( 'All Data (2)' ),
            VALUES ( 'All Data (2)'[NavSalesFuels.CustomerPod] )
        ),
        'All Data (2)'[ShiftDate] >= __MinDate
            && 'All Data (2)'[ShiftDate] <= __Date
            && 'All Data (2)'[True Zero Count] = 1
    )
VAR __Result =
    COUNTROWS ( SUMMARIZE ( __Table, 'All Data (2)'[ShiftDate] ) )
RETURN
    __Result

[BharathM]

Hi @tamerj1 

The measure you have sent is only passing 1 and 2 not appropirate counts related to that customerpod

i'm expecting left table to have totals it was my measure 

in the right i have implemented your measure result is as above

[tamerj1 · Accepted solution]

@BharathM 
Please try

Measure1 =
VAR __Date =
    MAX ( 'All Data (2)'[ShiftDate] )
VAR __MinDate =
    EDATE ( __Date, -12 )
VAR __Result =
    SUMX (
        VALUES ( 'All Data (2)'[NavSalesFuels.CustomerPod] ),
        VAR __CurrentPod = 'All Data (2)'[NavSalesFuels.CustomerPod]
        VAR __Table =
            FILTER (
                ALL ( 'All Data (2)' ),
                'All Data (2)'[NavSalesFuels.CustomerPod] = __CurrentPod
                    && 'All Data (2)'[ShiftDate] >= __MinDate
                    && 'All Data (2)'[ShiftDate] <= __Date
                    && 'All Data (2)'[True Zero Count] = 1
            )
        RETURN
            COUNTROWS ( SUMMARIZE ( __Table, 'All Data (2)'[ShiftDate] ) )
    )
RETURN
    __Result

[BharathM]

@tamerj1 

Thank you so much it's working