{"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":"DAX formule: COUNTROWS i 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\">Sadr\u017eaj<\/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>\nAgregacija (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.\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;Ocenite post&quot;,&quot;legend&quot;:&quot;0\\\/5 - (0 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;DAX formule: COUNTROWS i 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\">Ocenite post<\/span>\n    <\/div>\n    <\/div>","protected":false},"excerpt":{"rendered":"<p>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 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=\"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\":\"DAX formule: COUNTROWS i 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\":\"sr-SR\",\"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\":\"sr-SR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/dax-formule-countrows-filter\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sr-SR\",\"@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\":\"sr-SR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sr-SR\",\"@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":"DAX formule: COUNTROWS i 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":"sr-SR","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":"sr-SR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/dax-formule-countrows-filter\/"]}]},{"@type":"ImageObject","inLanguage":"sr-SR","@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":"sr-SR"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"sr-SR","@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}]}}