I went back and tried the formula with First and Filter and everything works now. Not sure why it didn't work yesterday though.
Was the formula throwing a delegation error? Increasing the limit to 2000 solving the issue would lead me to suspect it was....
@mdevaney no I didn't get the little yellow triangle or a warning. I recreated the back-end at the same time then re-connected the data source so either fixing the backend or increasing that worked, I'm leaning towards recreating the backend.
In any case, I'm glad you figured it out!
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand