Drill Through with comma separated values

Hi Anonymous,

The “Query has exceeded the available resources” error in Power BI occurs when the engine is unable to process a query due to limitations in memory, CPU, or execution capacity. This issue is related to the system's capacity or the complexity of the query, rather than a DAX syntax error.

To resolve this issue:

• Avoid using a measure as a visual-level filter on a detailed table.
• Incorporate the logic into the data model by creating a calculated column, such as

Has Affiliation Change =
IF (
    CONTAINSSTRING (
        'AFFILIATION CHANGE FLAG'[affiliation_change_category],
        RELATED ( 'Dim Affiliation Category Bridge'[affiliation_change_category] )
    ),
    1,
    0
)

Use slicers or dimension tables to apply filters, rather than using measures.

Thank you.