Forum Discussion

_Regina's avatar
_Regina
Helper I
2 years ago
Solved

ALL function not behaving as expected

Hi everyone,   I have the following measure. What I am trying to do here is get the number of distinct 'onboarding ids' where there is a transaction.   Onboarding ID is in a fact table named 'Onb...
  • AlexisOlson's avatar
    AlexisOlson
    2 years ago

    The measure [_Product Net Sales Buy Sell Transaction Count] still has the date filter context active.

     

    Maybe removing the date filtering in the definition of b will help.

    VAR b =
    SELECTCOLUMNS (
        CALCULATETABLE (
            FILTER (
                ALL ( 'Sales Transactions'[ACCOUNT_DIM_SYSID] ),
                [_Product Net Sales Buy Sell Transaction Count] > 0
            ),
            ALL ( 'Date' )
        ),
        "ACCOUNT_DIM_SYSID", 'Sales Transactions'[ACCOUNT_DIM_SYSID] + 0
    )
AlexisOlson's avatar
AlexisOlson
Super User
2 years ago

The measure [_Product Net Sales Buy Sell Transaction Count] still has the date filter context active.

 

Maybe removing the date filtering in the definition of b will help.

VAR b =
    SELECTCOLUMNS (
        CALCULATETABLE (
            FILTER (
                ALL ( 'Sales Transactions'[ACCOUNT_DIM_SYSID] ),
                [_Product Net Sales Buy Sell Transaction Count] > 0
            ),
            ALL ( 'Date' )
        ),
        "ACCOUNT_DIM_SYSID", 'Sales Transactions'[ACCOUNT_DIM_SYSID] + 0
    )