Forum Discussion

fabiomanniti's avatar
fabiomanniti
Icon for Helper III rankHelper III
4 years ago
Solved

Filter OR across different tables

Hello, I would like to count the users that made at least one sale among different products. The problem is those products are on different tables, so I would like somethink like   CALCULATE( COUN...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, fabiomanniti 

    Please try measure as below:

    Result =
CALCULATE (
    COUNT ( User[UserID] ),
    FILTER (
        User,
        User[UserID]
            IN VALUES ( sales1[userID] )
                || User[UserID]
                    IN VALUES ( sales2[UserID] )
                        || User[UserID] IN VALUES ( sales3[UserID] )
    )
)

    Please check my sample file for more details.

     

    Best Regards,
    Community Support Team _ Eason

fabiomanniti's avatar
fabiomanniti
Icon for Helper III rankHelper III
4 years ago

Doesn't work.
For the way the function FILTER is made you have to chose only one table

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, fabiomanniti 

Please try measure as below:

Result =
CALCULATE (
    COUNT ( User[UserID] ),
    FILTER (
        User,
        User[UserID]
            IN VALUES ( sales1[userID] )
                || User[UserID]
                    IN VALUES ( sales2[UserID] )
                        || User[UserID] IN VALUES ( sales3[UserID] )
    )
)

Please check my sample file for more details.

 

Best Regards,
Community Support Team _ Eason