{"id":3067,"date":"2023-03-03T10:53:52","date_gmt":"2023-03-03T10:53:52","guid":{"rendered":"https:\/\/monocroft.com\/?p=3067"},"modified":"2023-03-03T10:53:54","modified_gmt":"2023-03-03T10:53:54","slug":"how-to-use-allnoblankrow-with-union-in-power-bi","status":"publish","type":"post","link":"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/","title":{"rendered":"How to Use ALLNOBLANKROW with Union in Power BI"},"content":{"rendered":"\n<p>The ALLNOBLANKROW function is a powerful DAX function that can be used to remove blank rows from a table or a result set. In Power BI, the ALLNOBLANKROW function with UNION removes the blank rows from the resulting table.<\/p>\n\n\n\n<p>This function can help improve data quality, enhance report performance, improve data visualization, and so on.<\/p>\n\n\n\n<p>In this article, I will explain a step-by-step method on how to use the ALLNOBLANKROW function with UNION in Power BI.<\/p>\n\n\n\n<p>Let&#8217;s get started.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Getting started: How to Use ALLNOBLANKROW with Union in Power BI<\/h2>\n\n\n\n<p>Follow the below steps to use the ALLNOBLANKROW with Union in Power BI:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Create a new measure<\/h2>\n\n\n\n<p>To get started, the first thing to do is to create a new measure. To do that, open the Power BI Desktop and go to the <strong>Modeling <\/strong>tab, then click on <strong>New Measure.<\/strong> <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"718\" height=\"129\" src=\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/02\/image-32.png\" alt=\"\" class=\"wp-image-3081\" srcset=\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/02\/image-32.png 718w, https:\/\/monocroft.com\/wp-content\/uploads\/2023\/02\/image-32-300x54.png 300w, https:\/\/monocroft.com\/wp-content\/uploads\/2023\/02\/image-32-150x27.png 150w\" sizes=\"(max-width: 718px) 100vw, 718px\" \/><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\">Enter the formula<\/h2>\n\n\n\n<p>In the <strong>New Measure<\/strong> dialog box, enter the following formula:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong><code>Measure_Name = UNION(ALLNOBLANKROW(TableX), ALLNOBLANKROW(TableY))<\/code><\/strong><\/pre>\n\n\n\n<p><em>Don&#8217;t forget to replace <strong>Measure_Name<\/strong> with the name of your new measure. Also, replace <strong>TableX<\/strong> and <strong>TableY<\/strong> with the names of the tables that you want to <strong>UNION<\/strong>.<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Save the measure<\/h2>\n\n\n\n<p>Finally, click <strong>Enter<\/strong> to create the new measure. Now, you can drag the new measure to a new or existing visual in the report.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">FAQs: How to Use ALLNOBLANKROW with Union in Power BI<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Can ALLNOBLANKROW be used with other functions?<\/h3>\n\n\n\n<p><strong>Yes, it can. <\/strong><\/p>\n\n\n\n<p>You can use the <strong><code>ALLNOBLANKROW <\/code>function with functions such as <code>JOIN <\/code>or <code>APPEND<\/code>, to remove blank rows and improve data quality.<\/strong><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">How does the ALLNOBLANKROW function work?<\/h3>\n\n\n\n<p>The function <strong>removes any blank rows from a table or dataset<\/strong>. This can help to avoid issues with duplicate or missing data.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Are there any limitations to using the ALLNOBLANKROW function?<\/h3>\n\n\n\n<p><strong>Yes, there is. <\/strong><\/p>\n\n\n\n<p>It <strong>may increase the amount of processing time and memory required, especially for large datasets. <\/strong><\/p>\n\n\n\n<p>Also, removing blank rows may not always be good, as it <strong>can sometimes result in data loss.<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion: How to Use ALLNOBLANKROW with Union in Power BI<\/h2>\n\n\n\n<p>By following these steps, you should be able to use the <code><strong>ALLNOBLANKROW<\/strong> <\/code>function with <strong><code>UNION <\/code><\/strong>in Power BI. <\/p>\n\n\n\n<p>The <strong><code>ALLNOBLANKROW <\/code><\/strong>function removes every blank row before performing the <code>UNION <\/code>operation, which can help to avoid issues with duplicate or missing data. <\/p>\n\n\n\n<p>Finally, the <strong><code>ALLNOBLANKROW <\/code><\/strong>function is an important tool for Power BI developers and data analysts who work with large datasets and generate accurate insights. And by removing the blank rows, they can improve the quality of their data.<\/p>\n\n\n\n<p>I hope you understood these steps.<\/p>\n\n\n\n<p>Thanks for reading!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The ALLNOBLANKROW function is a powerful DAX function that can be used to remove blank rows from a table or &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Use ALLNOBLANKROW with Union in Power BI\" class=\"read-more button\" href=\"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/#more-3067\" aria-label=\"More on How to Use ALLNOBLANKROW with Union in Power BI\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":3069,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,8],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Use ALLNOBLANKROW with Union in Power BI - Monocroft<\/title>\n<meta name=\"description\" content=\"Learn how to use the ALLNOBLANKROW function with UNION in Power BI to remove blank rows before performing a UNION operation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Use ALLNOBLANKROW with Union in Power BI - Monocroft\" \/>\n<meta property=\"og:description\" content=\"Learn how to use the ALLNOBLANKROW function with UNION in Power BI to remove blank rows before performing a UNION operation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"Monocroft\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-03T10:53:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-03T10:53:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/02\/How-to-use-allnoblankrow-with-union-in-power-bi-monocroft.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"720\" \/>\n\t<meta property=\"og:image:height\" content=\"405\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Matt\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Matt\" \/>\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\":\"Article\",\"@id\":\"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/\"},\"author\":{\"name\":\"Matt\",\"@id\":\"https:\/\/monocroft.com\/#\/schema\/person\/3aeab97c9b5661d211c0742c48f024b3\"},\"headline\":\"How to Use ALLNOBLANKROW with Union in Power BI\",\"datePublished\":\"2023-03-03T10:53:52+00:00\",\"dateModified\":\"2023-03-03T10:53:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/\"},\"wordCount\":423,\"publisher\":{\"@id\":\"https:\/\/monocroft.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/02\/How-to-use-allnoblankrow-with-union-in-power-bi-monocroft.jpg\",\"articleSection\":[\"Guides\",\"PowerBI\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/\",\"url\":\"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/\",\"name\":\"How to Use ALLNOBLANKROW with Union in Power BI - Monocroft\",\"isPartOf\":{\"@id\":\"https:\/\/monocroft.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/02\/How-to-use-allnoblankrow-with-union-in-power-bi-monocroft.jpg\",\"datePublished\":\"2023-03-03T10:53:52+00:00\",\"dateModified\":\"2023-03-03T10:53:54+00:00\",\"description\":\"Learn how to use the ALLNOBLANKROW function with UNION in Power BI to remove blank rows before performing a UNION operation.\",\"breadcrumb\":{\"@id\":\"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/#primaryimage\",\"url\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/02\/How-to-use-allnoblankrow-with-union-in-power-bi-monocroft.jpg\",\"contentUrl\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/02\/How-to-use-allnoblankrow-with-union-in-power-bi-monocroft.jpg\",\"width\":720,\"height\":405,\"caption\":\"How to use allnoblankrow with union in power bi - monocroft\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/monocroft.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Use ALLNOBLANKROW with Union in Power BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/monocroft.com\/#website\",\"url\":\"https:\/\/monocroft.com\/\",\"name\":\"Monocroft\",\"description\":\"Monocroft Tech\",\"publisher\":{\"@id\":\"https:\/\/monocroft.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/monocroft.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/monocroft.com\/#organization\",\"name\":\"Triburge\",\"url\":\"https:\/\/monocroft.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/monocroft.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/07\/monocroft-logo.png\",\"contentUrl\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/07\/monocroft-logo.png\",\"width\":512,\"height\":512,\"caption\":\"Triburge\"},\"image\":{\"@id\":\"https:\/\/monocroft.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/monocroft.com\/#\/schema\/person\/3aeab97c9b5661d211c0742c48f024b3\",\"name\":\"Matt\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/monocroft.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c06bcee4d38a649222493c5e9f11f7a5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c06bcee4d38a649222493c5e9f11f7a5?s=96&d=mm&r=g\",\"caption\":\"Matt\"},\"url\":\"https:\/\/monocroft.com\/author\/matthew\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Use ALLNOBLANKROW with Union in Power BI - Monocroft","description":"Learn how to use the ALLNOBLANKROW function with UNION in Power BI to remove blank rows before performing a UNION operation.","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:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"How to Use ALLNOBLANKROW with Union in Power BI - Monocroft","og_description":"Learn how to use the ALLNOBLANKROW function with UNION in Power BI to remove blank rows before performing a UNION operation.","og_url":"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/","og_site_name":"Monocroft","article_published_time":"2023-03-03T10:53:52+00:00","article_modified_time":"2023-03-03T10:53:54+00:00","og_image":[{"width":720,"height":405,"url":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/02\/How-to-use-allnoblankrow-with-union-in-power-bi-monocroft.jpg","type":"image\/jpeg"}],"author":"Matt","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Matt","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/#article","isPartOf":{"@id":"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/"},"author":{"name":"Matt","@id":"https:\/\/monocroft.com\/#\/schema\/person\/3aeab97c9b5661d211c0742c48f024b3"},"headline":"How to Use ALLNOBLANKROW with Union in Power BI","datePublished":"2023-03-03T10:53:52+00:00","dateModified":"2023-03-03T10:53:54+00:00","mainEntityOfPage":{"@id":"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/"},"wordCount":423,"publisher":{"@id":"https:\/\/monocroft.com\/#organization"},"image":{"@id":"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/02\/How-to-use-allnoblankrow-with-union-in-power-bi-monocroft.jpg","articleSection":["Guides","PowerBI"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/","url":"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/","name":"How to Use ALLNOBLANKROW with Union in Power BI - Monocroft","isPartOf":{"@id":"https:\/\/monocroft.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/02\/How-to-use-allnoblankrow-with-union-in-power-bi-monocroft.jpg","datePublished":"2023-03-03T10:53:52+00:00","dateModified":"2023-03-03T10:53:54+00:00","description":"Learn how to use the ALLNOBLANKROW function with UNION in Power BI to remove blank rows before performing a UNION operation.","breadcrumb":{"@id":"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/#primaryimage","url":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/02\/How-to-use-allnoblankrow-with-union-in-power-bi-monocroft.jpg","contentUrl":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/02\/How-to-use-allnoblankrow-with-union-in-power-bi-monocroft.jpg","width":720,"height":405,"caption":"How to use allnoblankrow with union in power bi - monocroft"},{"@type":"BreadcrumbList","@id":"https:\/\/monocroft.com\/how-to-use-allnoblankrow-with-union-in-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/monocroft.com\/"},{"@type":"ListItem","position":2,"name":"How to Use ALLNOBLANKROW with Union in Power BI"}]},{"@type":"WebSite","@id":"https:\/\/monocroft.com\/#website","url":"https:\/\/monocroft.com\/","name":"Monocroft","description":"Monocroft Tech","publisher":{"@id":"https:\/\/monocroft.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/monocroft.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/monocroft.com\/#organization","name":"Triburge","url":"https:\/\/monocroft.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/monocroft.com\/#\/schema\/logo\/image\/","url":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/07\/monocroft-logo.png","contentUrl":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/07\/monocroft-logo.png","width":512,"height":512,"caption":"Triburge"},"image":{"@id":"https:\/\/monocroft.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/monocroft.com\/#\/schema\/person\/3aeab97c9b5661d211c0742c48f024b3","name":"Matt","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/monocroft.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c06bcee4d38a649222493c5e9f11f7a5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c06bcee4d38a649222493c5e9f11f7a5?s=96&d=mm&r=g","caption":"Matt"},"url":"https:\/\/monocroft.com\/author\/matthew\/"}]}},"_links":{"self":[{"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/posts\/3067"}],"collection":[{"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/comments?post=3067"}],"version-history":[{"count":63,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/posts\/3067\/revisions"}],"predecessor-version":[{"id":4222,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/posts\/3067\/revisions\/4222"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/media\/3069"}],"wp:attachment":[{"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/media?parent=3067"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/categories?post=3067"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/tags?post=3067"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}