Forum Discussion

Yiyi's avatar
Yiyi
Icon for Helper I rankHelper I
3 years ago
Solved

A table created by table function can not be used in VALUE() function?

Hello, this is my code and to me, it looks all fine, but the error message said that Cannot find table 'AISearchUsers' when I used it with VALUE() after RETURN hoping to use it as a list to filter my...
"DAX"
DAX SUMMARIZE
  • nandukrishnavs's avatar
    nandukrishnavs
    3 years ago

    Yiyi 

     

    try this 

    Make yourCount_users_who_only_use_keyword_search =
VAR AISearchUsers =
    SUMMARIZE (
        FILTER (
            'Query 3',
            'Query 3'[IsAISearch] = "true"
        ),
        'Query 3'[user_Id]
    )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( 'Query 3'[user_Id] ),
        FILTER (
            'Query 3',
            NOT ( [user_Id] IN AISearchUsers )
        ),
        'Query 3'[IsAISearch] = "false"
    )
nandukrishnavs's avatar
nandukrishnavs
Icon for Community Champion rankCommunity Champion
3 years ago

Yiyi 

 

try this 

Make yourCount_users_who_only_use_keyword_search =
VAR AISearchUsers =
    SUMMARIZE (
        FILTER (
            'Query 3',
            'Query 3'[IsAISearch] = "true"
        ),
        'Query 3'[user_Id]
    )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( 'Query 3'[user_Id] ),
        FILTER (
            'Query 3',
            NOT ( [user_Id] IN AISearchUsers )
        ),
        'Query 3'[IsAISearch] = "false"
    )
Yiyi's avatar
Yiyi
Icon for Helper I rankHelper I
3 years ago

It works! Appreciate your time and attention 🙂