Forum Discussion
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.
Hi lbendlin
Data is pretty simple. I have a category column which contains fruit names.
Some values are individual and some are comma separated.
| Category |
| Apple |
| Banana |
| Guava |
| Pineapple |
| Apple, Orange |
| Banana, Guava |
If I drill through on Apple, I should see values for Apple + Apple, Orange.
Similary, if I drill through on Banana, I should see values for Banana + Banana, Guava
Super User
hi lbendlin
Will this solution be recommended if I have a large table with number of rows close to 2 Billion?
Duplicating the entire table will consume double memory and degrade the performance.- lbendlin
This data is immutable so you can also consider precomputing it once, either in Power Query or further upstream.
lbendlin Thanks.
I am drilling through from a bar chart where categories are pulled from a Dimension table.
And on drill through page fact table is used. So which one to duplicate and transformed?