skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Microsoft 365 + Power BI
    • Dynamics 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Getting started
      • Overview
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Microsoft Power BI Community
    • Welcome to the Community!
    • News & Announcements
    • Get Help with Power BI
    • Desktop
    • Service
    • Report Server
    • Power Query
    • Mobile Apps
    • Developer
    • DAX Commands and Tips
    • Custom Visuals Development Discussion
    • Health and Life Sciences
    • Power BI Spanish Community
    • Translated Spanish Desktop
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Training and Consulting
    • Instructor Led Training
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    • Ideas
    • Custom Visuals Ideas
    • Issues
    • Issues
    • Events
    • Upcoming Events
    • Community Engagement
    • T-Shirt Design Challenge 2023
    • Community Blog
    • Power BI Community Blog
    • Custom Visuals Community Blog
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • Quick Measures Gallery
    • Re: Simple Aggregation Quick Measures

    Re: Simple Aggregation Quick Measures

    05-20-2020 04:43 AM

    SGusau
    Advocate I
    15384 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    MattAllington
    MattAllington
    MVP
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Simple Aggregation Quick Measures

    ‎07-12-2017 07:02 PM

    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.
    Preview file
    72 KB
    Labels:
    • Labels:
    • Other
    Message 1 of 7
    32,533 Views
    37
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    SGusau
    SGusau Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-20-2020 04:43 AM

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

    Message 7 of 7
    15,384 Views
    0
    Reply
    mike_honey
    mike_honey Memorable Member
    Memorable Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎02-21-2019 10:45 AM

    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

    Message 6 of 7
    25,917 Views
    0
    Reply
    nickchobotar
    nickchobotar Skilled Sharer
    Skilled Sharer
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎08-16-2017 08:41 AM

    Hi @MattAllington

     

     

    Post this as an idea and we will go vote.

     

    N-

     

    image.png

     

     

     

     

     

     

    Message 4 of 7
    31,497 Views
    0
    Reply
    MattAllington
    MattAllington
    MVP
    In response to nickchobotar
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎08-17-2017 03:43 AM

    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.
    Message 5 of 7
    31,482 Views
    2
    Reply
    MyNameHere
    MyNameHere Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-13-2017 04:47 PM

    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. 

    Message 3 of 7
    32,091 Views
    1
    Reply
    Phil_Seamark
    Microsoft Phil_Seamark
    Microsoft
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-12-2017 07:33 PM

    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!

    Message 2 of 7
    32,465 Views
    0
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2023 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    Consumer Privacy Act (CCPA) Opt-Out Icon Your Privacy Choices