Simple Aggregation Quick Measures
The Quick Measures feature is a great tool to create more complex DAX. But I see this feature as a tool to help brand new users get started with DAX too. I train Excel users on how to write DAX, and it is not intuitive to most of them how to write simple measures. If you included some "Basic Aggregations" as a group in Quick Measures, this would significantly help new users get started on the DAX journey. I would like to see the following basic aggregations added to a new group in quick measures.
=SUM(<selected column>)
=AVERAGE(<selected column>)
=COUNT(<selected column>)
=DISTINCTCOUNT(<selected column>)
=MAX(<selected column>)
=MIN(<selected column>)
Yes I know all of these things can be created as implicit measures, but as you know implicit measures lack reuse, formatting and naming flexibilty vs a true measure.
6 Replies
As a user, this is an obvious win.
If the implicit measure UI created an explicit measure or was another door into the UI for quick measures, so that implicit measures went away it would simplify and focus the development experience.
Implicit measures were Quick Measures v0.9.
Time to kill off that the early draft now.
I find the lack of formatting the most frustation part of implicit measures. Nice idea Matt!
There are 2 ways you can submit and idea. Here, and also in the ideas link. Both are monitored by MS.
Great idea, sadly long neglected/ignored while rounded corners were perfected ...
I'd extend it just a touch to include the typical CALCULATE ... FILTER ... pattern
It is, indeed, simple but intutive and would help new comers alot.
