{"id":1725,"date":"2020-09-04T06:31:29","date_gmt":"2020-09-04T06:31:29","guid":{"rendered":"https:\/\/bi.unija.com\/en\/?p=1725"},"modified":"2020-10-22T11:47:21","modified_gmt":"2020-10-22T11:47:21","slug":"implicit-and-explicit-measures-in-power-bi","status":"publish","type":"post","link":"https:\/\/bi.unija.com\/en\/implicit-and-explicit-measures-in-power-bi\/","title":{"rendered":"Implicit and Explicit Measures in Power BI"},"content":{"rendered":"

For Power BI version 2.76.5678.782 (December 2019).<\/em><\/p>\n

Measures<\/h1>\n

Measure is a formula that tells Power BI what to do with data. Most often measures are aggregations, for example sum, average, count, etc. Power Bi knows implicit and explicit measures. We usually avoid implicit measures and try to use explicit measures whenever we can. Let’s look at characteristics of both.<\/p>\n

Implicit measures<\/h1>\n

Power BI creates implicit measures by itself. Let’s look at a table with a filed named Price<\/strong>.<\/p>\n

<\/p>\n

In field pane we see a sum icon next to Price name, meaning the field contains numerical data that will be aggregated to a sum. We create a Table visualization and drag Price <\/strong>field to Values<\/strong>.<\/p>\n

<\/p>\n

Value we get is a sum of all the prices in the Price<\/strong> field. We can check to confirm this is a sum: we click the arrow by the name Price and see which of the aggregations is marked. In our case this is indeed a Sum<\/strong>.<\/p>\n

<\/p>\n

In this place we can also change the measure to any of the other aggregations: average, maximum, minimum, standard deviation, etc.<\/p>\n

Problem with implicit measures is we can’t use them in other measures. For example, if we want to add Price<\/strong> and Tax<\/strong> column, we have to use explicit measures.<\/p>\n

Explicit measures<\/h1>\n

Whenever possible, we use explicit measures. Their advantage is we can use them as a reference in other measures. We also can’t change them, unless we change the formula of the measure.<\/p>\n

Let’s look at explicit measure Price_EXPLICIT<\/strong>, that does the same as implicit measure Price<\/strong>.<\/p>\n

1. Right click to field pane and select New Measure<\/strong>.<\/p>\n

<\/p>\n

2. Enter Price_EXPLICIT = SUM(Sales[Price])<\/strong> to formula bar, where Sales <\/strong> is a table name and Price<\/strong> is a field name.<\/p>\n

<\/p>\n

3. Confirm with Enter<\/strong>.<\/p>\n

We created explicit measure. We add it to the table from a previous example. We see they give the same result.<\/p>\n

<\/p>\n

Using explicit measure in another measure<\/h2>\n

Biggest advantage of explicit measures is the fact we can use them in other measure and build complex formulas. Let’s look at a simple example of adding two columns Price<\/strong> and Tax<\/strong>.<\/p>\n

1. Right click and select New Measure<\/strong>.<\/p>\n

2. Enter Tax_EXPLICIT = SUM(Sales[Tax])<\/strong> to formula bar, where Sales<\/strong> is the name of the table and Tax<\/strong> is the field name.<\/p>\n

<\/p>\n

3. Confirm with Enter<\/strong>.<\/p>\n

4. Right click and select New Measure<\/strong>.<\/p>\n

5. Enter TotalPrice = [Price_EXPLICIT] + [Tax_EXPLICT] <\/strong> to formula bar.<\/p>\n

<\/p>\n

6. Confirm with Enter<\/strong>.<\/p>\n

We created TotalPrice<\/strong> measure, that adds two other measures. We can insert all measure into a table and check the results.<\/p>\n

<\/p>\n

Measures can be very complex. They enable us to use custom slicers and other skillful tools. Example of a custom slicer can be found in Monthly and YTD filter in one measure article.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

For Power BI version 2.76.5678.782 (December 2019). Measures Measure is a formula that tells Power BI what to do with data. Most often measures are aggregations, for example sum, average, count, etc. Power Bi knows implicit and explicit measures. We<\/p>\n","protected":false},"author":5,"featured_media":1735,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[4],"tags":[8],"class_list":["post-1725","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-advanced","tag-power-bi"],"acf":[],"yoast_head":"\nImplicit and Explicit Measures in Power BI - Bi Unija<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bi.unija.com\/en\/implicit-and-explicit-measures-in-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Implicit and Explicit Measures in Power BI - Bi Unija\" \/>\n<meta property=\"og:description\" content=\"For Power BI version 2.76.5678.782 (December 2019). Measures Measure is a formula that tells Power BI what to do with data. Most often measures are aggregations, for example sum, average, count, etc. Power Bi knows implicit and explicit measures. We\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bi.unija.com\/en\/implicit-and-explicit-measures-in-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"Bi Unija\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-04T06:31:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-22T11:47:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/09\/22eng.png\" \/>\n\t<meta property=\"og:image:width\" content=\"720\" \/>\n\t<meta property=\"og:image:height\" content=\"480\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Branka Trifunovi\u0107\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Branka Trifunovi\u0107\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/bi.unija.com\/en\/implicit-and-explicit-measures-in-power-bi\/\",\"url\":\"https:\/\/bi.unija.com\/en\/implicit-and-explicit-measures-in-power-bi\/\",\"name\":\"Implicit and Explicit Measures in Power BI - Bi Unija\",\"isPartOf\":{\"@id\":\"https:\/\/bi.unija.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/bi.unija.com\/en\/implicit-and-explicit-measures-in-power-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/bi.unija.com\/en\/implicit-and-explicit-measures-in-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/09\/22eng.png\",\"datePublished\":\"2020-09-04T06:31:29+00:00\",\"dateModified\":\"2020-10-22T11:47:21+00:00\",\"author\":{\"@id\":\"https:\/\/bi.unija.com\/en\/#\/schema\/person\/3bed36623727c7162e421c4366a54e10\"},\"breadcrumb\":{\"@id\":\"https:\/\/bi.unija.com\/en\/implicit-and-explicit-measures-in-power-bi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/bi.unija.com\/en\/implicit-and-explicit-measures-in-power-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/bi.unija.com\/en\/implicit-and-explicit-measures-in-power-bi\/#primaryimage\",\"url\":\"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/09\/22eng.png\",\"contentUrl\":\"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/09\/22eng.png\",\"width\":720,\"height\":480},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/bi.unija.com\/en\/implicit-and-explicit-measures-in-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/bi.unija.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Implicit and Explicit Measures in Power BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/bi.unija.com\/en\/#website\",\"url\":\"https:\/\/bi.unija.com\/en\/\",\"name\":\"Bi Unija\",\"description\":\"Just another Bi site\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/bi.unija.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/bi.unija.com\/en\/#\/schema\/person\/3bed36623727c7162e421c4366a54e10\",\"name\":\"Branka Trifunovi\u0107\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/bi.unija.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ec99f651bcc98a163161515ec254b974?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ec99f651bcc98a163161515ec254b974?s=96&d=mm&r=g\",\"caption\":\"Branka Trifunovi\u0107\"},\"url\":\"https:\/\/bi.unija.com\/en\/author\/branka\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Implicit and Explicit Measures in Power BI - Bi Unija","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:\/\/bi.unija.com\/en\/implicit-and-explicit-measures-in-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"Implicit and Explicit Measures in Power BI - Bi Unija","og_description":"For Power BI version 2.76.5678.782 (December 2019). Measures Measure is a formula that tells Power BI what to do with data. Most often measures are aggregations, for example sum, average, count, etc. Power Bi knows implicit and explicit measures. We","og_url":"https:\/\/bi.unija.com\/en\/implicit-and-explicit-measures-in-power-bi\/","og_site_name":"Bi Unija","article_published_time":"2020-09-04T06:31:29+00:00","article_modified_time":"2020-10-22T11:47:21+00:00","og_image":[{"width":720,"height":480,"url":"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/09\/22eng.png","type":"image\/png"}],"author":"Branka Trifunovi\u0107","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Branka Trifunovi\u0107","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/bi.unija.com\/en\/implicit-and-explicit-measures-in-power-bi\/","url":"https:\/\/bi.unija.com\/en\/implicit-and-explicit-measures-in-power-bi\/","name":"Implicit and Explicit Measures in Power BI - Bi Unija","isPartOf":{"@id":"https:\/\/bi.unija.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bi.unija.com\/en\/implicit-and-explicit-measures-in-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/bi.unija.com\/en\/implicit-and-explicit-measures-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/09\/22eng.png","datePublished":"2020-09-04T06:31:29+00:00","dateModified":"2020-10-22T11:47:21+00:00","author":{"@id":"https:\/\/bi.unija.com\/en\/#\/schema\/person\/3bed36623727c7162e421c4366a54e10"},"breadcrumb":{"@id":"https:\/\/bi.unija.com\/en\/implicit-and-explicit-measures-in-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bi.unija.com\/en\/implicit-and-explicit-measures-in-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bi.unija.com\/en\/implicit-and-explicit-measures-in-power-bi\/#primaryimage","url":"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/09\/22eng.png","contentUrl":"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/09\/22eng.png","width":720,"height":480},{"@type":"BreadcrumbList","@id":"https:\/\/bi.unija.com\/en\/implicit-and-explicit-measures-in-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bi.unija.com\/en\/"},{"@type":"ListItem","position":2,"name":"Implicit and Explicit Measures in Power BI"}]},{"@type":"WebSite","@id":"https:\/\/bi.unija.com\/en\/#website","url":"https:\/\/bi.unija.com\/en\/","name":"Bi Unija","description":"Just another Bi site","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bi.unija.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/bi.unija.com\/en\/#\/schema\/person\/3bed36623727c7162e421c4366a54e10","name":"Branka Trifunovi\u0107","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bi.unija.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ec99f651bcc98a163161515ec254b974?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ec99f651bcc98a163161515ec254b974?s=96&d=mm&r=g","caption":"Branka Trifunovi\u0107"},"url":"https:\/\/bi.unija.com\/en\/author\/branka\/"}]}},"_links":{"self":[{"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/posts\/1725"}],"collection":[{"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/comments?post=1725"}],"version-history":[{"count":1,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/posts\/1725\/revisions"}],"predecessor-version":[{"id":1736,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/posts\/1725\/revisions\/1736"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/media\/1735"}],"wp:attachment":[{"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/media?parent=1725"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/categories?post=1725"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/tags?post=1725"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}