{"id":33346,"date":"2021-01-20T10:59:06","date_gmt":"2021-01-20T10:59:06","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=33346"},"modified":"2021-01-20T10:59:08","modified_gmt":"2021-01-20T10:59:08","slug":"using-quick-measures","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/using-quick-measures\/","title":{"rendered":"Using Quick Measures"},"content":{"rendered":"\n<p>You may use quick measures for performing common, powerful calculations quickly. Primarily, a quick measure runs a set of Data Analysis Expressions (DAX) commands behind the scenes, and thereby presents the results to use in your report. Also, there is no need to write the Data Analysis Expressions (DAX) commands, since it is done for you based on input provided in a dialog box. It offers many available categories of calculations and ways to modify each calculation to fit your needs. Further, you can view the DAX that&#8217;s executed by the quick measure and jump-start with the same.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Steps to create a Quick Measure<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, \u00a0right-click or select the ellipsis\u00a0<strong>&#8230;<\/strong>\u00a0next to any item in the\u00a0<strong>Fields<\/strong>\u00a0pane, then select\u00a0<strong>New quick measure<\/strong>\u00a0from the menu that appears.<\/li><li>In the second steps, after selecting\u00a0<strong>New quick measure<\/strong>, the\u00a0<strong>Quick measures<\/strong>\u00a0window appears, letting you select the calculation you want and the fields to run the calculation against.<\/li><li>Next, select the\u00a0<strong>Select a calculation<\/strong>\u00a0field to see a long list of available quick measures.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Quick Measure Calculation<\/strong><\/h4>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td><strong>Quick Measure Calculation Types<\/strong><\/td><td><strong>Calculations<\/strong><\/td><\/tr><tr><td><strong>Aggregate per category<\/strong><\/td><td>Average per category<br>Variance per category<br>Max per category<br>Min per category<br>Weighted average per category<\/td><\/tr><tr><td><strong>Filters<\/strong><\/td><td>Filtered value<br>Difference from filtered value<br>Percentage difference from filtered value<br>Sales from new customers<\/td><\/tr><tr><td><strong>Time intelligence<\/strong><\/td><td>Year-to-date total<br>Quarter-to-date total<br>Month-to-date total<br>Year-over-year change<br>Quarter-over-quarter change<br>Month-over-month change<br>Rolling average<\/td><\/tr><tr><td><strong>Totals<\/strong><\/td><td>Running total<br>Total for category (filters applied)<br>Total for category (filters not applied)<\/td><\/tr><tr><td><strong>Mathematical operations<\/strong><\/td><td>Addition<br>Subtraction<br>Multiplication<br>Division<br>Percentage difference<br>Correlation coefficient<\/td><\/tr><tr><td><strong>Text<\/strong><\/td><td>Star rating<br>Concatenated list of values<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Things to keep in mind when using Quick Measure<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, you can use quick measures added to the\u00a0<strong>Fields<\/strong>\u00a0pane with any visual in the report.<\/li><li>Secondly, you can always see the DAX associated with a quick measure by selecting the measure in the\u00a0<strong>Fields<\/strong>\u00a0list (in the formula bar).<\/li><li>Thirdly, quick measures are available only if you can modify the model<\/li><li>Lastly, you can&#8217;t create time intelligence quick measures when working in DirectQuery mode. <\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image is-style-default\"><a href=\"https:\/\/www.testpreptraining.ai\/analyzing-data-with-microsoft-power-bi-da-100-free-test\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png\" alt=\"Microsoft Exam DA-100 Free Practice Test\"\/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>You may use quick measures for performing common, powerful calculations quickly. Primarily, a quick measure runs a set of Data Analysis Expressions (DAX) commands behind the scenes, and thereby presents the results to use in your report. Also, there is no need to write the Data Analysis Expressions (DAX) commands, since it is done for&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[174],"tags":[1830,3955,3954,4117],"class_list":["post-33346","page","type-page","status-publish","hentry","category-microsoft-azure","tag-da-100-study-guide","tag-microsoft-exam-da-100-exam-questions","tag-microsoft-exam-da-100-free-practice-test","tag-using-quick-measures"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Using Quick Measures - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Learn to define and use quick measures with online tutorial and practice test. Start preparing for Microsoft Exam DA-100 Now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/using-quick-measures\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Quick Measures - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Learn to define and use quick measures with online tutorial and practice test. Start preparing for Microsoft Exam DA-100 Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/using-quick-measures\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-20T10:59:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/using-quick-measures\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/using-quick-measures\/\",\"name\":\"Using Quick Measures - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2021-01-20T10:59:06+00:00\",\"dateModified\":\"2021-01-20T10:59:08+00:00\",\"description\":\"Learn to define and use quick measures with online tutorial and practice test. Start preparing for Microsoft Exam DA-100 Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/using-quick-measures\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/using-quick-measures\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/using-quick-measures\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Quick Measures\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using Quick Measures - Testprep Training Tutorials","description":"Learn to define and use quick measures with online tutorial and practice test. Start preparing for Microsoft Exam DA-100 Now!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.testpreptraining.ai\/tutorial\/using-quick-measures\/","og_locale":"en_US","og_type":"article","og_title":"Using Quick Measures - Testprep Training Tutorials","og_description":"Learn to define and use quick measures with online tutorial and practice test. Start preparing for Microsoft Exam DA-100 Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/using-quick-measures\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2021-01-20T10:59:08+00:00","og_image":[{"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/using-quick-measures\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/using-quick-measures\/","name":"Using Quick Measures - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2021-01-20T10:59:06+00:00","dateModified":"2021-01-20T10:59:08+00:00","description":"Learn to define and use quick measures with online tutorial and practice test. Start preparing for Microsoft Exam DA-100 Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/using-quick-measures\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/using-quick-measures\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/using-quick-measures\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Using Quick Measures"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/33346","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=33346"}],"version-history":[{"count":2,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/33346\/revisions"}],"predecessor-version":[{"id":33351,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/33346\/revisions\/33351"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=33346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=33346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=33346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}