Forum Discussion

ReadTheIron's avatar
ReadTheIron
Helper III
3 years ago
Solved

CalculateTable filtered by another table

I have two tables, FailureTable and DisqualifiedTable. FailureTable has millions of entries, but I only want to work with a small subset of that table. I've created a calculated table based on Failur...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi ReadTheIron ,

    You can update the formula of calculated table 'WorkingTable' as below and check if it will return the expected result.... Please find the details in the attachment.

    WorkingTable =
CALCULATETABLE (
    'FailureTable',
    FILTER (
        'FailureTable',
        'FailureTable'[Type] = "Green"
            && NOT ( 'FailureTable'[FailureID] IN VALUES ( 'DisqualifiedTable'[FailureID] ) )
    )
)

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi ReadTheIron ,

You can update the formula of calculated table 'WorkingTable' as below and check if it will return the expected result.... Please find the details in the attachment.

WorkingTable =
CALCULATETABLE (
    'FailureTable',
    FILTER (
        'FailureTable',
        'FailureTable'[Type] = "Green"
            && NOT ( 'FailureTable'[FailureID] IN VALUES ( 'DisqualifiedTable'[FailureID] ) )
    )
)

Best Regards