I've been trying to incorporate LINESTX into my reporting but keep running into errors when modifying the filter context.
To create a minimal reproducible example, I've loaded a data table like...
I was curious so I downloaded the example and played a little bit.
0/ When I tried to open the file, some window quickly popped up and disappeared. I believe Power Pivot generated an exception that was not intercepted by Power BI Desktop.
1/ If I clear ID slicer then LINESTX() indeed is working.
2/ BUT, If I select 3 groups in Group slicer, then clear ID slicer, and then filter ID by Power BI filter pane everything is working fine.
So I think there is incorrect interaction between slicers and LINESTX() and as result there is a memory exception.