Forum Discussion
Solved
DAX Query help
Hello, I have 2 tables in the model 1. CUSTTRANS RECID, ACCOUNTNUM, TANSDATE, AMOUNT, EXCHADJUSTMENT, TANSTYPE 2. CUSTSETTLEMENT TRANSRECID, TRANSDATE, EXCHADJUSTMENT, SETTLEAMOUNT 3. Cal...
Thanks for the script.
Though not exactly what I want but has given me an idea and I fixed the measure with RELATEDTABLE() function. Its giving the result and the performance is also good
Hi krish42 ,
Thanks for reaching out to the Microsoft Fabric Community forum.
The error is occurring because the DAX measure is forcing the engine to generate and process a very large intermediate result set during query execution, which exceeds the 15MB per-query data limit enforced by the Tabular engine.
As an immediate workaround, you can try reducing the dataset being evaluated before running the measure. For example:
- Apply a date filter (e.g., specific month or year) in the report using slicers.
- Filter by a specific AccountNum or a smaller customer subset.
- Use report-level or page-level filters to limit the number of transactions loaded into the visual.
- Temporarily test the measure on a smaller date range to confirm it works correctly.
I hope this information helps. Please do let us know if you have any further queries.
Thank you