{"id":83303,"date":"2022-07-04T01:21:40","date_gmt":"2022-07-03T23:21:40","guid":{"rendered":"https:\/\/rmarketingdigital.com\/powerbi\/filtros-de-power-bi-en-medidas\/"},"modified":"2020-09-16T20:42:23","modified_gmt":"2020-09-16T23:42:23","slug":"filtros-de-power-bi-en-medidas","status":"publish","type":"post","link":"https:\/\/rmarketingdigital.com\/en\/powerbi\/filtros-de-power-bi-en-medidas\/","title":{"rendered":"Power BI filters on measures"},"content":{"rendered":"<div>\n<p>How to create Power BI filters on measures with an example? You use Power BI measure filters to filter measures (metric values). For example, we can use Power BI filters on measures to show products with sales above the threshold or below the average, etc.<\/p>\n<p><span id=\"ezoic-pub-ad-placeholder-104\"\/><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:90px;min-width:728px;text-align:center !important;\" class=\"ezoic-ad medrectangle-3 adtester-container adtester-container-104\" data-ez-name=\"tutorialgateway_org-medrectangle-3\"><span id=\"div-gpt-ad-tutorialgateway_org-medrectangle-3-0\" ezaw=\"728\" ezah=\"90\" style=\"position:relative;z-index:0;display:inline-block;width:100%;max-width:1200px;margin-left:auto !important;margin-right:auto !important;min-height:90px;min-width:728px;\" class=\"ezoic-ad\"\/><\/span><\/p>\n<h2>How to use Power BI filters in measures<\/h2>\n<p>To demonstrate measure filters in Power BI, we&#039;ll use the bar chart we created in our previous post. As you can see in the Power BI screenshot below, we used the name of the state province as an axis field. And we use the sales amount as a value field and the order quantity as the color saturation.<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-filters-on-measures-1-5857032' width='1226' height='735' class=\"wp-image-31314\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-1-5857032.png 1226w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-1-5857032-300x180.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-1-5857032-1024x614.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-1-5857032-768x460.png 768w' data-lazy-sizes='(max-width: 1226px) 100vw, 1226px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-1-5857032.png'\/><noscript><img alt='power-bi-filters-on-measures-1-5857032' width='1226' height='735' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-1-5857032.png' class=\"wp-image-31314\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-1-5857032.png 1226w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-1-5857032-300x180.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-1-5857032-1024x614.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-1-5857032-768x460.png 768w' sizes='(max-width: 1226px) 100vw, 1226px'\/><\/noscript><\/figure>\n<p>In the Filters section, you can see the list of Power BI filters available on measures.<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-filters-on-measures-2-4013174' width='1220' height='726' class=\"wp-image-31315\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-2-4013174.png 1220w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-2-4013174-300x179.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-2-4013174-1024x609.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-2-4013174-768x457.png 768w' data-lazy-sizes='(max-width: 1220px) 100vw, 1220px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-2-4013174.png'\/><noscript><img alt='power-bi-filters-on-measures-2-4013174' width='1220' height='726' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-2-4013174.png' class=\"wp-image-31315\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-2-4013174.png 1220w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-2-4013174-300x179.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-2-4013174-1024x609.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-2-4013174-768x457.png 768w' sizes='(max-width: 1220px) 100vw, 1220px'\/><\/noscript><\/figure>\n<p>Let me expand the sales amount to see the filter options. The following is the list of options that are available for measure filters in Power BI.<\/p>\n<ul>\n<li><b>Show items when value: <\/b>Select the operator you want to use.<\/li>\n<li><b>Empty text box:<\/b> Specify the value.<\/li>\n<li><b>And me:<\/b> Same as the AND and OR SQL operators. Use this to concatenate multiple filters.<\/li>\n<li><b>Empty dropdown list:<\/b> Select the second operator you want to use.<\/li>\n<li><b>Empty text box:<\/b> Specify the value of the second filter.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt='power-bi-filters-on-measures-3-4410471' width='1220' height='726' class=\"wp-image-31316\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-3-4410471.png 1220w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-3-4410471-300x179.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-3-4410471-1024x609.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-3-4410471-768x457.png 768w' data-lazy-sizes='(max-width: 1220px) 100vw, 1220px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-3-4410471.png'\/><noscript><img alt='power-bi-filters-on-measures-3-4410471' width='1220' height='726' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-3-4410471.png' class=\"wp-image-31316\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-3-4410471.png 1220w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-3-4410471-300x179.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-3-4410471-1024x609.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-3-4410471-768x457.png 768w' sizes='(max-width: 1220px) 100vw, 1220px'\/><\/noscript><\/figure>\n<p>Here is the list of Power BI filter options on measures available in the Show items when value section:<\/p>\n<p><span id=\"ezoic-pub-ad-placeholder-105\"\/><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:400px;min-width:580px;text-align:center !important;\" class=\"ezoic-ad box-4 adtester-container adtester-container-105\" data-ez-name=\"tutorialgateway_org-box-4\"><span id=\"div-gpt-ad-tutorialgateway_org-box-4-0\" ezaw=\"580\" ezah=\"400\" style=\"position:relative;z-index:0;display:inline-block;width:100%;max-width:1200px;margin-left:auto !important;margin-right:auto !important;min-height:400px;min-width:580px;\" class=\"ezoic-ad ezoic-adl\"\/><\/span><\/p>\n<ol>\n<li><b>it&#039;s less than:<\/b> When this option is selected, it verifies each record with the <b>Value<\/b>. And if it is less than the value specified by the user, then the record is displayed.<\/li>\n<li><b>is less than or equal to:<\/b> If it is less than or equal to the given value, then the record is displayed.<\/li>\n<li><b>is greater than:<\/b> Shows records whose sales amount is greater than the specified value<\/li>\n<li><b>is greater than or equal to:<\/b> Shows records whose sales amount is greater than or equal to a given value.<\/li>\n<li><b>is:<\/b> If the record exactly matches the <b>value,<\/b> then the registration screen.<\/li>\n<li><b>It is not:<\/b> If the record is not equal to <b>value,<\/b> then the registration screen.<\/li>\n<li><b>it is blank:<\/b> Show all records with blank values.<\/li>\n<li><b>not blank:<\/b> Shows all records that do not contain blank values.<\/li>\n<\/ol>\n<figure class=\"wp-block-image\"><img alt='power-bi-filters-on-measures-4-4938958' width='244' height='409' class=\"wp-image-31317\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-4-4938958.png 244w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-4-4938958-179x300.png 179w' data-lazy-sizes='(max-width: 244px) 100vw, 244px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-4-4938958.png'\/><noscript><img alt='power-bi-filters-on-measures-4-4938958' width='244' height='409' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-4-4938958.png' class=\"wp-image-31317\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-4-4938958.png 244w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-4-4938958-179x300.png 179w' sizes='(max-width: 244px) 100vw, 244px'\/><\/noscript><\/figure>\n<p>For this purpose of demonstrating measure filters in Power BI, we select <strong>is greater than<\/strong> as operator and 1000000 as value.<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-filters-on-measures-5-9934802' width='1220' height='725' class=\"wp-image-31318\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-5-9934802.png 1220w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-5-9934802-300x178.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-5-9934802-1024x609.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-5-9934802-768x456.png 768w' data-lazy-sizes='(max-width: 1220px) 100vw, 1220px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-5-9934802.png'\/><noscript><img alt='power-bi-filters-on-measures-5-9934802' width='1220' height='725' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-5-9934802.png' class=\"wp-image-31318\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-5-9934802.png 1220w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-5-9934802-300x178.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-5-9934802-1024x609.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-5-9934802-768x456.png 768w' sizes='(max-width: 1220px) 100vw, 1220px'\/><\/noscript><\/figure>\n<p>The following report shows the statuses whose Sales Amount is greater than 1,000,000.<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-filters-on-measures-6-3951475' width='1220' height='726' class=\"wp-image-31319\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-6-3951475.png 1220w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-6-3951475-300x179.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-6-3951475-1024x609.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-6-3951475-768x457.png 768w' data-lazy-sizes='(max-width: 1220px) 100vw, 1220px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-6-3951475.png'\/><noscript><img alt='power-bi-filters-on-measures-6-3951475' width='1220' height='726' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-6-3951475.png' class=\"wp-image-31319\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-6-3951475.png 1220w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-6-3951475-300x179.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-6-3951475-1024x609.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-6-3951475-768x457.png 768w' sizes='(max-width: 1220px) 100vw, 1220px'\/><\/noscript><\/figure>\n<p>Let me change the operator to <strong>it&#039;s less than<\/strong> and value as 1000. In the image below, you can see that the report shows the statuses whose sales amount is less than 1000<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-filters-on-measures-7-9529734' width='1220' height='727' class=\"wp-image-31320\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-7-9529734.png 1220w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-7-9529734-300x179.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-7-9529734-1024x610.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-7-9529734-768x458.png 768w' data-lazy-sizes='(max-width: 1220px) 100vw, 1220px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-7-9529734.png'\/><noscript><img alt='power-bi-filters-on-measures-7-9529734' width='1220' height='727' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-7-9529734.png' class=\"wp-image-31320\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-7-9529734.png 1220w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-7-9529734-300x179.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-7-9529734-1024x610.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-7-9529734-768x458.png 768w' sizes='(max-width: 1220px) 100vw, 1220px'\/><\/noscript><\/figure>\n<p>This time we are using the <b>it is blank<\/b> operator. You can see that the report is blank because we do not have any status that contains blank sales.<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-filters-on-measures-8-5479230' width='1220' height='726' class=\"wp-image-31321\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-8-5479230.png 1220w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-8-5479230-300x179.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-8-5479230-1024x609.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-8-5479230-768x457.png 768w' data-lazy-sizes='(max-width: 1220px) 100vw, 1220px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-8-5479230.png'\/><noscript><img alt='power-bi-filters-on-measures-8-5479230' width='1220' height='726' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-8-5479230.png' class=\"wp-image-31321\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-8-5479230.png 1220w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-8-5479230-300x179.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-8-5479230-1024x609.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-8-5479230-768x457.png 768w' sizes='(max-width: 1220px) 100vw, 1220px'\/><\/noscript><\/figure>\n<p>Let me use several filters on the Sales Amount column. The first filter searches for states with sales greater than 300,000, and the second filter searches for states with sales less than 2,300,000.<\/p>\n<p>We use the AND operator to join those two filters<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-filters-on-measures-9-2744828' width='1287' height='801' class=\"wp-image-31322\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-9-2744828.png 1287w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-9-2744828-300x187.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-9-2744828-1024x637.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-9-2744828-768x478.png 768w' data-lazy-sizes='(max-width: 1287px) 100vw, 1287px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-9-2744828.png'\/><noscript><img alt='power-bi-filters-on-measures-9-2744828' width='1287' height='801' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-9-2744828.png' class=\"wp-image-31322\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-9-2744828.png 1287w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-9-2744828-300x187.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-9-2744828-1024x637.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-9-2744828-768x478.png 768w' sizes='(max-width: 1287px) 100vw, 1287px'\/><\/noscript><\/figure>\n<p>In the screenshot below, you can see that the report shows the statuses whose sales amount is greater than 300000 and less than 2300000.<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-filters-on-measures-10-8462934' width='1223' height='736' class=\"wp-image-31323\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-10-8462934.png 1223w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-10-8462934-300x181.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-10-8462934-1024x616.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-10-8462934-768x462.png 768w' data-lazy-sizes='(max-width: 1223px) 100vw, 1223px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-10-8462934.png'\/><noscript><img alt='power-bi-filters-on-measures-10-8462934' width='1223' height='736' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-10-8462934.png' class=\"wp-image-31323\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-10-8462934.png 1223w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-10-8462934-300x181.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-10-8462934-1024x616.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-10-8462934-768x462.png 768w' sizes='(max-width: 1223px) 100vw, 1223px'\/><\/noscript><\/figure>\n<p>The report below shows the statuses whose sales amount is greater than 300,000 or the sales amount is less than 1,000.<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-filters-on-measures-11-5884958' width='1223' height='739' class=\"wp-image-31324\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-11-5884958.png 1223w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-11-5884958-300x181.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-11-5884958-1024x619.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-11-5884958-768x464.png 768w' data-lazy-sizes='(max-width: 1223px) 100vw, 1223px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-11-5884958.png'\/><noscript><img alt='power-bi-filters-on-measures-11-5884958' width='1223' height='739' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-11-5884958.png' class=\"wp-image-31324\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-11-5884958.png 1223w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-11-5884958-300x181.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-11-5884958-1024x619.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-11-5884958-768x464.png 768w' sizes='(max-width: 1223px) 100vw, 1223px'\/><\/noscript><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>\u00bfC\u00f3mo crear filtros de Power BI en medidas con un ejemplo? Los filtros de medidas de Power BI se utilizan para filtrar las medidas (valores de m\u00e9tricas). Por ejemplo, podemos&#8230;<\/p>","protected":false},"author":1,"featured_media":83304,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1359,1360],"tags":[],"class_list":["post-83303","post","type-post","status-publish","format-standard","has-post-thumbnail","category-powerbi","category-tutoriales-power-bi"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.0 (Yoast SEO v28.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Filtros de Power BI en medidas - R Marketing Digital<\/title>\n<meta name=\"description\" content=\"\u00bfC\u00f3mo crear filtros de Power BI en medidas con un ejemplo? Los filtros de medidas de Power BI se utilizan para filtrar las medidas (valores de m\u00e9tricas).\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/bi-in-size-power-filter\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Filtros de Power BI en medidas\" \/>\n<meta property=\"og:description\" content=\"\u00bfC\u00f3mo crear filtros de Power BI en medidas con un ejemplo? Los filtros de medidas de Power BI se utilizan para filtrar las medidas (valores de m\u00e9tricas).\" \/>\n<meta property=\"og:url\" content=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/bi-in-size-power-filter\/\" \/>\n<meta property=\"og:site_name\" content=\"R Marketing Digital\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-03T23:21:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-10-7705776.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1223\" \/>\n\t<meta property=\"og:image:height\" content=\"736\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"R Marketing Digital\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/de\\\/powerbi\\\/bi-in-size-power-filter\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/de\\\/powerbi\\\/bi-in-size-power-filter\\\/\"},\"author\":{\"name\":\"R Marketing Digital\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"headline\":\"Filtros de Power BI en medidas\",\"datePublished\":\"2022-07-03T23:21:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/de\\\/powerbi\\\/bi-in-size-power-filter\\\/\"},\"wordCount\":601,\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/de\\\/powerbi\\\/bi-in-size-power-filter\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-Filters-on-Measures-10-7705776.png\",\"articleSection\":[\"Power BI\",\"Tutoriales PowerBI\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/de\\\/powerbi\\\/bi-in-size-power-filter\\\/\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/de\\\/powerbi\\\/bi-in-size-power-filter\\\/\",\"name\":\"Filtros de Power BI en medidas - R Marketing Digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/de\\\/powerbi\\\/bi-in-size-power-filter\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/de\\\/powerbi\\\/bi-in-size-power-filter\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-Filters-on-Measures-10-7705776.png\",\"datePublished\":\"2022-07-03T23:21:40+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"description\":\"\u00bfC\u00f3mo crear filtros de Power BI en medidas con un ejemplo? Los filtros de medidas de Power BI se utilizan para filtrar las medidas (valores de m\u00e9tricas).\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/de\\\/powerbi\\\/bi-in-size-power-filter\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/de\\\/powerbi\\\/bi-in-size-power-filter\\\/#primaryimage\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-Filters-on-Measures-10-7705776.png\",\"contentUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-Filters-on-Measures-10-7705776.png\",\"width\":1223,\"height\":736,\"caption\":\"power-bi-filters-on-measures-10-7705776-1142969-png\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/\",\"name\":\"R Marketing Digital\",\"description\":\"Agencia SEO | Publicidad redes sociales | Community Management\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/rmarketingdigital.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\",\"name\":\"R Marketing Digital\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"caption\":\"R Marketing Digital\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Filtros de Power BI en medidas - R Marketing Digital","description":"How to create Power BI filters on measures with an example? You use Power BI measure filters to filter measures (metric values).","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:\/\/rmarketingdigital.com\/en\/powerbi\/bi-in-size-power-filter\/","og_locale":"en_US","og_type":"article","og_title":"Filtros de Power BI en medidas","og_description":"\u00bfC\u00f3mo crear filtros de Power BI en medidas con un ejemplo? Los filtros de medidas de Power BI se utilizan para filtrar las medidas (valores de m\u00e9tricas).","og_url":"https:\/\/rmarketingdigital.com\/en\/powerbi\/bi-in-size-power-filter\/","og_site_name":"R Marketing Digital","article_published_time":"2022-07-03T23:21:40+00:00","og_image":[{"width":1223,"height":736,"url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-10-7705776.png","type":"image\/png"}],"author":"R Marketing Digital","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/rmarketingdigital.com\/de\/powerbi\/bi-in-size-power-filter\/#article","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/de\/powerbi\/bi-in-size-power-filter\/"},"author":{"name":"R Marketing Digital","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"headline":"Filtros de Power BI en medidas","datePublished":"2022-07-03T23:21:40+00:00","mainEntityOfPage":{"@id":"https:\/\/rmarketingdigital.com\/de\/powerbi\/bi-in-size-power-filter\/"},"wordCount":601,"image":{"@id":"https:\/\/rmarketingdigital.com\/de\/powerbi\/bi-in-size-power-filter\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-10-7705776.png","articleSection":["Power BI","Tutoriales PowerBI"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/rmarketingdigital.com\/de\/powerbi\/bi-in-size-power-filter\/","url":"https:\/\/rmarketingdigital.com\/de\/powerbi\/bi-in-size-power-filter\/","name":"Filtros de Power BI en medidas - R Marketing Digital","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/rmarketingdigital.com\/de\/powerbi\/bi-in-size-power-filter\/#primaryimage"},"image":{"@id":"https:\/\/rmarketingdigital.com\/de\/powerbi\/bi-in-size-power-filter\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-10-7705776.png","datePublished":"2022-07-03T23:21:40+00:00","author":{"@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"description":"How to create Power BI filters on measures with an example? You use Power BI measure filters to filter measures (metric values).","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/de\/powerbi\/bi-in-size-power-filter\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/rmarketingdigital.com\/de\/powerbi\/bi-in-size-power-filter\/#primaryimage","url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-10-7705776.png","contentUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-Filters-on-Measures-10-7705776.png","width":1223,"height":736,"caption":"power-bi-filters-on-measures-10-7705776-1142969-png"},{"@type":"WebSite","@id":"https:\/\/rmarketingdigital.com\/#website","url":"https:\/\/rmarketingdigital.com\/","name":"R Digital Marketing","description":"SEO Agency | Advertising social networks | Community Management","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/rmarketingdigital.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e","name":"R Digital Marketing","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g","caption":"R Marketing Digital"}}]}},"_links":{"self":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts\/83303","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/comments?post=83303"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts\/83303\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media\/83304"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media?parent=83303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/categories?post=83303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/tags?post=83303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}