cancel
Showing results for 
Search instead for 
Did you mean: 

Simple Aggregation Quick Measures

11382 Views
Super User
Super User

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.  

 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Highlighted
Phil_Seamark Super Contributor
Super Contributor

Re: Simple Aggregation Quick Measures

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


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

MyNameHere Frequent Visitor
Frequent Visitor

Re: Simple Aggregation Quick Measures

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. 

nickchobotar Established Member
Established Member

Re: Simple Aggregation Quick Measures

Hi @MattAllington

 

 

Post this as an idea and we will go vote.

 

N-

 

image.png

 

 

 

 

 

 

Super User
Super User

Re: Simple Aggregation Quick Measures

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



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
mike_honey
Advisor

Re: Simple Aggregation Quick Measures

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