Forum Discussion
DAX query optimisation
Hi, I have this DAX query: Days Shorted = VAR _Table = SUMMARIZE( 'Outbound Delivery', 'Product Category'[Level 2], 'Date'[Date], "@Shorted", 'O...
Hi Justas4478 without model and relationships, it is hard to spot issue.
some_bih The one thing I noticed if I remove
This from the table rows:
It loads data almoust instantly.
This is realationship between 'Product' table and 'Outbound Delivery' table that holds query.
Because it is using live data model I can't do any changes to set realationships.
I dont know is this any helpfull.
Hi Justas4478 not enought to provide some solution from my side 🙂
Play a bit with CALCULATETABLE so you filterout blank result (combination measure without +0 and filter <> blank rows for text column