Filter context issue - different values for total and on bar chart

[GunnerJ]

I have a measure that counts the rows of a flagged value. When looking at a card or the count next to a table with account #s the value seems plausible. When I throw that value on a bar chart I get some wild totals which are actually several times greater than my supposed grand total. 

Below (left) card just showing total. (right) same measure with an x-axis from the same table.

Here is the measure being used.

Total Pendings = 
VAR __Table9 = 
    CALCULATETABLE(
        GENERATE( 
            VALUES( 'MASTER CHARGE ACTIONS'[BI_ACCT]),
            SELECTCOLUMNS(
                TOPN(1, FILTER( 'MASTER CHARGE ACTIONS', 'MASTER CHARGE ACTIONS'[Total Pending Flag] >= 1),
                    'MASTER CHARGE ACTIONS'[ROWRANK]
                ),
                "CHG_DATE", 'MASTER CHARGE ACTIONS'[CHG_DATE],
                "Account Status", 'MASTER CHARGE ACTIONS'[Account Status]
            )
        ),
        ALLEXCEPT('MASTER CHARGE ACTIONS','MASTER CHARGE ACTIONS'[BI_ACCT],'MASTER CHARGE ACTIONS'[Zone])
    )

var result = COUNTROWS( FILTER( __Table9, 'MASTER CHARGE ACTIONS'[Total Pending Flag] <> BLANK()) )

return result 

Shared file location below

https://www.dropbox.com/s/mnggk57lf6eccnv/OZARKSGO%202.0.pbix?dl=0

Any help in explaining why the totals are being altered with the new filter context would be appreciated. 

[v-henryk-mstf · Accepted solution]

Hi @GunnerJ ,

Need to change the filtering context in the formula.

Total Pendings = 
VAR __Table9 = 
    CALCULATETABLE(
        GENERATE( 
            VALUES( 'MASTER CHARGE ACTIONS'[BI_ACCT]),
            SELECTCOLUMNS(
                TOPN(1, FILTER( 'MASTER CHARGE ACTIONS', 'MASTER CHARGE ACTIONS'[Total Pending Flag] >= 1),
                    'MASTER CHARGE ACTIONS'[ROWRANK]
                ),
                "CHG_DATE", 'MASTER CHARGE ACTIONS'[CHG_DATE],
                "Account Status", 'MASTER CHARGE ACTIONS'[Account Status]
            )
        ),
        ALL('MASTER CHARGE ACTIONS'[BI_ACCT],'MASTER CHARGE ACTIONS'[Zone])
    )

var result = COUNTROWS( FILTER( __Table9, 'MASTER CHARGE ACTIONS'[Total Pending Flag] <> BLANK()) )

return result 

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[GunnerJ]

@v-henryk-mstf  thank you for the solution! If you didn't mind explaining why the ALL in this case was the solution I'd appreciate the opportunity to learn. 

Thank you again.