{"id":1152,"date":"2018-01-08T17:56:34","date_gmt":"2018-01-08T16:56:34","guid":{"rendered":"http:\/\/kalkulacija.com\/wordpress\/?p=1152"},"modified":"2022-05-16T19:49:05","modified_gmt":"2022-05-16T17:49:05","slug":"dax-formule-countrows-filter","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/en\/dax-formule-countrows-filter\/","title":{"rendered":"DAX formulas: COUNTROWS &#038; FILTER"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0d590e;color:#0d590e\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0d590e;color:#0d590e\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/dax-formule-countrows-filter\/#DAX_formula_COUNTROWS\" >DAX formula: COUNTROWS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/dax-formule-countrows-filter\/#DAX_formula_FILTER\" >DAX formula: FILTER<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/dax-formule-countrows-filter\/#COUTROWS_and_FILTER\" >COUTROWS and FILTER<\/a><\/li><\/ul><\/nav><\/div>\nAggregation (data aggregation) is what we implicitly do each time when we drag some sort of dimension into the Pivot field of Values, while using explicit definition of an ad with a large set of data, use the filter of the formulas COUNTROWS and FILTER. When we create more complicated reports, it is useful to use aggregation functions (sums, averages, counts) to measure them.<\/p>\n<p>Data aggregation formulas are SUM, AVERAGE and COUNT, and their syntax is the same as for the same Excel function. As an argument in DAX terms, they most often have a column. On the example we will show how we can make three measures in which these functions are used:<\/p>\n<p><strong>SumaKolicina: = SUM ([KOL])<\/strong><\/p>\n<p><strong>AverageKolicina: = AVERAGE ([KOL])<\/strong><\/p>\n<p><strong>NumberTransaction: = COUNT ([KOL])<\/strong><\/p>\n<p>In all three formulas, we used a column for the argument in which we recorded the quantities sold by retail, which are in our case listed in the Transaction table.<\/p>\n<figure id=\"attachment_924\" aria-describedby=\"caption-attachment-924\" style=\"width: 836px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-924 size-full\" src=\"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp2.png\" alt=\"COUTROWS i FILTER\" width=\"836\" height=\"585\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp2.png 836w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp2-350x245.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp2-300x210.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp2-768x537.png 768w\" sizes=\"auto, (max-width: 836px) 100vw, 836px\" \/><figcaption id=\"caption-attachment-924\" class=\"wp-caption-text\">COUTROWS i FILTER<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"COUTROWS_and_FILTER\"><\/span>COUTROWS and FILTER<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When looking for an average or counting elements that are not numerical data (a text containing numerous values), we can also use the functions AVERAGEA and COUNTA. They have the same syntax, and they work with a little different arguments. The COUNTBLANK function can be used to count empty rows in a given column, but most commonly using the formulas are COUNTROWS and FILTER.<\/p>\n<p>To count the total number of rows in the table, we use the formula COUNTROWS, which for the argument has the name of the table: COUNTROWS (&lt;table&gt;). if we want to count how many rows in the base,<\/p>\n<p><strong>Product number: = COUNTROWS (Items [Name])<\/strong><\/p>\n<p>DAX has a class of formulas that performs data filtering. For the given arguments, one returns the filtered table as a result. Usually they are used in combination with some other functions, and their specificity is that they allow the creation of measures that ignore the constraints of existing filters in the Pivot table, as well as interactive filters such as Slicers and Timeline.<\/p>\n<p>The most common filtering formula is FILTER, and its syntax is:<\/p>\n<p><strong>FILTER (&lt;table name&gt;, &lt;filter condition&gt;)<\/strong><\/p>\n<p>Usually used in combination with some of the data aggregation functions. For example, if we want to sum up the quantities of all beer sold, we would write:<\/p>\n<p><strong>SumaProdatihKolicinaPiva: = SUMX (FILTER (Items, [CLASSIFICATION] = &#8220;BEER&#8221;), [SUM KOL])<\/strong><\/p>\n<p>Formula FILTER is the first argument of the SUMX function and it must return all the rows in the Table Items where the CLASSIFICATION column has the value of &#8220;PIVA&#8221;. The second argument is implicitly given by the measure of the sum of the column. When the first argument is a filter, the second argument must be some measure.\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-right kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;right&quot;,&quot;id&quot;:&quot;1152&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;0&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;0&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;0\\\/5 - (0 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;DAX formulas: COUNTROWS \\u0026amp; FILTER&quot;,&quot;width&quot;:&quot;0&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 0px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            <span class=\"kksr-muted\">Rate this post<\/span>\n    <\/div>\n    <\/div>","protected":false},"excerpt":{"rendered":"<p>Aggregation (data aggregation) is what we implicitly do each time when we drag some sort of dimension into the Pivot<\/p>\n","protected":false},"author":1,"featured_media":1182,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43,39],"tags":[],"class_list":["post-1152","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-excel","category-powerpivot"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>DAX formule: COUNTROWS i FILTER<\/title>\n<meta name=\"description\" content=\"DAX formule: COUNTROWS i FILTER koristimo kao filterske formule koje omogu\u0107avaju kreiranje eksplicitnih dimenzija u analizi.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kalkulacija.com\/wordpress\/dax-formule-countrows-filter\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DAX formule: COUNTROWS i FILTER\" \/>\n<meta property=\"og:description\" content=\"DAX formule: COUNTROWS i FILTER koristimo kao filterske formule koje omogu\u0107avaju kreiranje eksplicitnih dimenzija u analizi.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/dax-formule-countrows-filter\/\" \/>\n<meta property=\"og:site_name\" content=\"Calculation in essence of everything!\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-08T16:56:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-05-16T17:49:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"648\" \/>\n\t<meta property=\"og:image:height\" content=\"654\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-countrows-filter\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-countrows-filter\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"DAX formulas: COUNTROWS &#038; FILTER\",\"datePublished\":\"2018-01-08T16:56:34+00:00\",\"dateModified\":\"2022-05-16T17:49:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-countrows-filter\\\/\"},\"wordCount\":893,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-countrows-filter\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/powerquery1.png\",\"articleSection\":[\"Power Excel\",\"PowerPivot\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-countrows-filter\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-countrows-filter\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-countrows-filter\\\/\",\"name\":\"DAX formule: COUNTROWS i FILTER\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-countrows-filter\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-countrows-filter\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/powerquery1.png\",\"datePublished\":\"2018-01-08T16:56:34+00:00\",\"dateModified\":\"2022-05-16T17:49:05+00:00\",\"description\":\"DAX formule: COUNTROWS i FILTER koristimo kao filterske formule koje omogu\u0107avaju kreiranje eksplicitnih dimenzija u analizi.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-countrows-filter\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-countrows-filter\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-countrows-filter\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/powerquery1.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/powerquery1.png\",\"width\":648,\"height\":654},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-countrows-filter\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DAX formule: COUNTROWS i FILTER\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\",\"name\":\"Calculation in essence of everything!\",\"description\":\"Go ahead! Improve your data processing skills!\",\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"width\":128,\"height\":128,\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DAX formule: COUNTROWS i FILTER","description":"DAX formule: COUNTROWS i FILTER koristimo kao filterske formule koje omogu\u0107avaju kreiranje eksplicitnih dimenzija u analizi.","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:\/\/kalkulacija.com\/wordpress\/dax-formule-countrows-filter\/","og_locale":"en_US","og_type":"article","og_title":"DAX formule: COUNTROWS i FILTER","og_description":"DAX formule: COUNTROWS i FILTER koristimo kao filterske formule koje omogu\u0107avaju kreiranje eksplicitnih dimenzija u analizi.","og_url":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-countrows-filter\/","og_site_name":"Calculation in essence of everything!","article_published_time":"2018-01-08T16:56:34+00:00","article_modified_time":"2022-05-16T17:49:05+00:00","og_image":[{"width":648,"height":654,"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery1.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-countrows-filter\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-countrows-filter\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"DAX formulas: COUNTROWS &#038; FILTER","datePublished":"2018-01-08T16:56:34+00:00","dateModified":"2022-05-16T17:49:05+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-countrows-filter\/"},"wordCount":893,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-countrows-filter\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery1.png","articleSection":["Power Excel","PowerPivot"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/dax-formule-countrows-filter\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-countrows-filter\/","url":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-countrows-filter\/","name":"DAX formule: COUNTROWS i FILTER","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-countrows-filter\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-countrows-filter\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery1.png","datePublished":"2018-01-08T16:56:34+00:00","dateModified":"2022-05-16T17:49:05+00:00","description":"DAX formule: COUNTROWS i FILTER koristimo kao filterske formule koje omogu\u0107avaju kreiranje eksplicitnih dimenzija u analizi.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-countrows-filter\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/dax-formule-countrows-filter\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-countrows-filter\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery1.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery1.png","width":648,"height":654},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/dax-formule-countrows-filter\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"DAX formule: COUNTROWS i FILTER"}]},{"@type":"WebSite","@id":"https:\/\/kalkulacija.com\/wordpress\/#website","url":"https:\/\/kalkulacija.com\/wordpress\/","name":"Calculation in essence of everything!","description":"Go ahead! Improve your data processing skills!","publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kalkulacija.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","width":128,"height":128,"caption":"admin"},"logo":{"@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png"}}]}},"_links":{"self":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/1152","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/comments?post=1152"}],"version-history":[{"count":7,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/1152\/revisions"}],"predecessor-version":[{"id":3028,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/1152\/revisions\/3028"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media\/1182"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media?parent=1152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/categories?post=1152"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/tags?post=1152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}