topic Re: Simple Aggregation Quick Measures in Quick Measures Gallery

Simple Aggregation Quick Measures

MattAllington — Thu, 13 Jul 2017 02:03:55 GMT

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.

Re: Simple Aggregation Quick Measures

Phil_Seamark — Thu, 13 Jul 2017 02:33:05 GMT

I find the lack of formatting the most frustation part of implicit measures. Nice idea Matt!

Re: Simple Aggregation Quick Measures

MyNameHere — Thu, 13 Jul 2017 23:47:17 GMT

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.

Re: Simple Aggregation Quick Measures

nickchobotar — Wed, 16 Aug 2017 15:41:52 GMT

Hi MattAllington

Post this as an idea and we will go vote.

N-

Re: Simple Aggregation Quick Measures

MattAllington — Thu, 17 Aug 2017 10:43:57 GMT

There are 2 ways you can submit and idea. Here, and also in the ideas link. Both are monitored by MS.

Re: Simple Aggregation Quick Measures

mike_honey — Thu, 21 Feb 2019 18:45:46 GMT

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

Re: Simple Aggregation Quick Measures

SGusau — Wed, 20 May 2020 11:43:31 GMT

It is, indeed, simple but intutive and would help new comers alot.