{"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\/dax-formule-countrows-filter\/","title":{"rendered":"[:sr]DAX formule: COUNTROWS i FILTER[:en]DAX formulas: COUNTROWS &#038; FILTER[:]"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_87_1 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\">[:sr]Sadr\u017eaj[:en] 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\/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\/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\/dax-formule-countrows-filter\/#COUTROWS_and_FILTER\" >COUTROWS and FILTER<\/a><\/li><\/ul><\/nav><\/div>\n[:sr]Agregacija (zdru\u017eivanje) podataka je ono \u0161to <em>implicitno<\/em> radimo svaki put kada prevu\u010demo neku izve\u0161tajnu dimenziju u pivot polje\u00a0<em><strong>Values<\/strong><\/em>, dok kod eksplicitnog definisanja nad velikim skupom podataka koristimo filterske formule COUNTROWS i FILTER. Kada kreiramo slo\u017eenije izve\u0161taje, korisno je da funkcije za agregaciju (sume, proseke, prebrojavanja) iskoristimo kako bi smo na osnovu njih napravili mere.<\/p>\n<p>Formule za agregaciju podataka su SUM, AVERAGE i COUNT, a sintaksa im je jednaka\u00a0kao kod istoimenih\u00a0<em>Excel<\/em>\u00a0funkcija. Kao argument u\u00a0<em>DAX<\/em>\u00a0izrazima one naj\u010de\u0161\u0107e imaju neku kolonu. Na primeru \u0107emo pokazati kako mo\u017eemo da napravimo\u00a0tri mere u kojima se koriste ove funkcije:<\/p>\n<p><strong>SumaKolicina:=SUM([KOL])<\/strong><\/p>\n<p><strong>ProsekKolicina:=AVERAGE([KOL])<\/strong><\/p>\n<p><strong>BrojTransakcija:=COUNT([KOL])<\/strong><\/p>\n<p>U sve tri formule smo za argument upotrebili kolonu u kojoj su evidentirane prodate koli\u010dine po maloprodajama, koje se u na\u0161em primeru nalaze u tabeli Transakcije.<\/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=\"https:\/\/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<p>Kada tra\u017eimo prosek ili prebrojavamo elemente koji nisu numeri\u010dki podaci (tekst koji sadr\u017ei brojne vrednosti) mo\u017eemo da iskoristimo i funkcije AVERAGEA i COUNTA. One imaju istu sintaksu, a rade sa malo druga\u010dijim argumentima. Funkcija COUNTBLANK mo\u017ee da se iskoristi za prebrojavanje praznih redova u nekoj zadatoj koloni, ali naj\u010de\u0161\u0107e upotrebljavae formule su COUNTROWS i FILTER.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"DAX_formula_COUNTROWS\"><\/span>DAX formula: COUNTROWS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Da bismo prebrojali ukupan broj redova u tabeli, koristimo formulu COUNTROWS, koja za argument ima naziv tabele: <strong>COUNTROWS (&lt;tabela&gt;)<\/strong>. ako \u017eelimo da prebrojimo koliko ima redova u bazi napisa\u0107emo:<\/p>\n<p><strong>BrojProizvoda:=COUNTROWS(Artikli[Naziv])<\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"DAX_formula_FILTER\"><\/span>DAX formula: FILTER<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>DAX poseduje klasu formula koja vr\u0161i filtriranje podataka. Za zadate argumente one kao rezultat vra\u0107aju filtriranu tabelu. Obi\u010dno se koriste u kombinaciji sa nekom drugom funkcijom, a njihova specifi\u010dnost je i da\u00a0dozvoljavaju da se kreiraju mere koje ignori\u0161u ograni\u010denja postoje\u0107ih filtera u Pivot tabeli, kao i interaktivnih filtera\u00a0kao \u0161to su\u00a0<em>Slicers<\/em>\u00a0i\u00a0<em>Timeline<\/em>.<\/p>\n<p>Naj\u010de\u0161\u0107e kori\u0161\u0107ena formula za filtriranje je FILTER, a njena sintaksa je:<\/p>\n<p><strong>FILTER(&lt;naziv tabele&gt;,&lt;uslov za filtriranje&gt;)<\/strong><\/p>\n<p>Obi\u010dno se koristi u kombinaciji sa nekom od funkcija za agregaciju podatka. Na primer, ako \u017eelimo da sumiramo koli\u010dine svih prodatih piva napisali bi izraz:<\/p>\n<p><strong>SumaProdatihKolicinaPiva:= SUMX(FILTER(Artikli,[KLASIFIKACIJA]=\u201cPIVA\u201c),[SUM of KOL])<\/strong><\/p>\n<p>Formula FILTER je prvi argument funkcije SUMX i ona treba da vrati sve redove\u00a0iz tabele Artikli kod kojih kolona KLASIFIKACIJA ima vrednost \u201cPIVA\u201d. Drugi argument je implicitno zadata mera suma kolona. Kada je prvi argument filter, drugi argument mora da bude neka mera.[:en]Aggregation (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=\"https:\/\/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;[:sr] Ocenite [:en]Rate this [:]post&quot;,&quot;legend&quot;:&quot;0\\\/5 - (0 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;[:sr]DAX formule: COUNTROWS i FILTER[:en]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\">[:sr] Ocenite [:en]Rate this [:]post<\/span>\n    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>[:sr]Agregacija (zdru\u017eivanje) podataka je ono \u0161to implicitno radimo svaki put kada prevu\u010demo neku izve\u0161tajnu dimenziju u pivot polje\u00a0Values, dok kod<\/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 v28.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=\"Kalkulacija u osnovi svega!\" \/>\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\":\"[:sr]DAX formule: COUNTROWS i FILTER[:en]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\":\"Kalkulacija u osnovi svega!\",\"description\":\"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!\",\"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":"Kalkulacija u osnovi svega!","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":"[:sr]DAX formule: COUNTROWS i FILTER[:en]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":"Kalkulacija u osnovi svega!","description":"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!","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\/wp-json\/wp\/v2\/posts\/1152","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/comments?post=1152"}],"version-history":[{"count":7,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/1152\/revisions"}],"predecessor-version":[{"id":3028,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/1152\/revisions\/3028"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media\/1182"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=1152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=1152"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=1152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}