@JohnG ,
Great question, and I’m eager to see the other responses. Here’s my $0.02:
I’m a firm believer that the best, fastest, most efficient DAX is the DAX you don’t have to write. When I was first learning DAX, I was very impressed by long, complex measures. Now, I find I’m much more impressed by clever solutions that prevent you from having to write long, complex measures, whether that’s better data modeling, moving data transformations further “upstream”, using the filter pane, etc.
I think there’s a general attitude that DAX is the “big boy” solution, but I don’t buy into that at all. See the thread below - with the filter pane, it took me one line of DAX, without the filter pane 59 lines. Writing 58 extra lines of DAX just seems silly to me, except in the case where you’re learning and want to force yourself to take the harder road.
- Brian