For anyone following along at home, here's the issue: I get a different result depending on whether my slicer is in "Between" mode or some other mode. @myersmiguel

Here's the relevant tables. Note that Year[Year] has a different max value (2004) than Time[Year], and this seems to cause the DAX to return the wrong result when a "Between" slicer used

Further to this, why does my DAX return an incorrect result when in "Between" mode - unless I change the max value of the table used to populate the Slicer to the max value of the table it is connected to. Note the correct result when I change the Slicer to a Tile layout.

Im not sure you non-Bruhler types know just how friggin hard it is to build truly useful dashboards with UX users enjoy and adopt, even leaving aside tooling deficiencies. It is damn hard even for experts because you need to get inside users’ jobs, needs, problems, heads.

You lucky, lucky bastard.

That’s nuts.

Me: “Wait, they added a CHOOSE function? Copilot: “Kidding, kidding”

Copilot: “Hold my beer”

Related. Me (after long vacation): "I can't remember what the equivalent function to Excel's CHOOSE is in #PowerBI DAX" <Writes ‘dax choose function’ in Bing searchbox> Bing:

Fuck it.