{"id":946,"date":"2019-08-04T06:20:15","date_gmt":"2019-08-04T06:20:15","guid":{"rendered":"http:\/\/blog.eticsolutions.ro\/?p=946"},"modified":"2020-01-20T06:58:16","modified_gmt":"2020-01-20T06:58:16","slug":"power-pivot-8-exemple-de-functii-dax-functia-calculate-2","status":"publish","type":"post","link":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\/","title":{"rendered":"Power Pivot (8) &#8211; Exemple de functii DAX. Functia CALCULATE (2)"},"content":{"rendered":"<p><span style=\"color: #800000;\"><strong><span style=\"color: #000000;\">Ince<a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Cursuri_gratuite_Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-841 alignleft\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Cursuri_gratuite_Excel.png\" alt=\"Cursuri_gratuite_Excel\" width=\"113\" height=\"114\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Cursuri_gratuite_Excel.png 176w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Cursuri_gratuite_Excel-150x152.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Cursuri_gratuite_Excel-100x101.png 100w\" sizes=\"auto, (max-width: 113px) 100vw, 113px\" \/><\/a>pand din 11 iulie 2016, vom publica in fiecare zi de luni si de joi cate un articol din seria de zece\u00a0cursuri gratuite dedicate Power Pivot pentru Excel 2013.<\/span><\/strong><\/span><\/p>\n<p><span style=\"color: #800000;\"><strong>ENJOY THE POWER! \ud83d\ude42<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>Se da un model de date, format din trei tabele, relationate astfel:<\/p>\n<figure id=\"attachment_944\" aria-describedby=\"caption-attachment-944\" style=\"width: 700px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_tables-relationships.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-944\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_tables-relationships.png\" alt=\"Power Pivot - Relationships betweeen tables - Microsoft Excel 2013\" width=\"700\" height=\"400\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_tables-relationships.png 700w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_tables-relationships-300x171.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_tables-relationships-100x57.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_tables-relationships-150x86.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_tables-relationships-200x114.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_tables-relationships-450x257.png 450w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_tables-relationships-600x343.png 600w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_tables-relationships-128x72.png 128w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><figcaption id=\"caption-attachment-944\" class=\"wp-caption-text\"><strong>Power Pivot &#8211; Relationships between tables &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-837 alignleft\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare.gif\" alt=\"semn exclamare\" width=\"27\" height=\"41\" \/><\/a><\/p>\n<p>Va aduceti aminte din articolele anterioare cum am creat<strong><span style=\"color: #800000;\"><a style=\"color: #800000;\" href=\"http:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-cum-se-realizeza-legatura-intre-tabele\/\" target=\"_blank\" rel=\"noopener noreferrer\"> legatura dintre tabele<\/a><\/span> <\/strong>si cum am realizat un <span style=\"color: #800000;\"><strong><a style=\"color: #800000;\" href=\"http:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-4-cum-arata-si-ce-optiuni-furnizeaza-pivot-table-utilizand-un-model-de-date\/\" target=\"_blank\" rel=\"noopener noreferrer\">Pivot Table de tip Power Pivot<\/a><\/strong><\/span> in baza unui <span style=\"color: #800000;\"><a style=\"color: #800000;\" href=\"http:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-cum-se-construieste-un-model-de-date\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>model de date<\/strong><\/a><\/span>.<\/p>\n<p>&nbsp;<\/p>\n<p>Am construit un raport sintetic Pivot Table de tip Power Pivot, pe asiguratori, care arata astfel:<\/p>\n<figure id=\"attachment_943\" aria-describedby=\"caption-attachment-943\" style=\"width: 648px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-sinteza-asiguratori.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-943\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-sinteza-asiguratori.png\" alt=\"Power Pivot - Pivot Table, sinteza pe asiguratori - Microsoft Excel 2013\" width=\"648\" height=\"295\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-sinteza-asiguratori.png 648w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-sinteza-asiguratori-300x137.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-sinteza-asiguratori-100x46.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-sinteza-asiguratori-150x68.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-sinteza-asiguratori-200x91.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-sinteza-asiguratori-450x205.png 450w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-sinteza-asiguratori-600x273.png 600w\" sizes=\"auto, (max-width: 648px) 100vw, 648px\" \/><\/a><figcaption id=\"caption-attachment-943\" class=\"wp-caption-text\"><strong>Power Pivot &#8211; Pivot Table, sinteza pe asiguratori &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p>Vrem sa realizam cateva campuri calculate de utilizator, care sa arate comparativ:<\/p>\n<ul>\n<li>Rata medie de incasare (valoare dauna\/ valoare incasari)<\/li>\n<li>Valoare medie daune dosare nefinalizate\/ numar total dosare<\/li>\n<li>Numar mediu dosare nefinalizate\/ numar total dosare<\/li>\n<\/ul>\n<p>Starea dosarului este inscrisa in coloana [Status dosar] din tabela <strong>dosare<\/strong> si poate avea una dintre urmatoarele valori: <strong>finalizat, acte incomplete, in lucru<\/strong>.<\/p>\n<ol>\n<li><span style=\"color: #800000;\"><strong>Rata medie de incasare<\/strong><\/span><\/li>\n<\/ol>\n<p>Este cea mai simplu de calculat masura, am realizat un camp calculat (<strong>Calculated Field<\/strong>), pe care l-am denumit chiar <strong>rata medie incasare<\/strong>.<\/p>\n<p>In meniul <strong>PowerPivot<\/strong>, apasati <strong>Calculated Fields<\/strong> si <strong>Add new Calculated Field<\/strong>.<\/p>\n<p>Calculati rata medie de incasare dupa formula:<\/p>\n<p><strong>=[Sum of Suma incasare]\/sum(dosare[Valoare dauna calculata\/de platit (EUR)])<\/strong><\/p>\n<p>Aceasta inseamna ca va fi calculate <strong>in context<\/strong> rata medie de incasare, prin impartirea totalului incasat la totalul daunei calculate).<\/p>\n<p><span style=\"color: #800000;\"><strong>Gata!<\/strong><\/span><\/p>\n<figure id=\"attachment_942\" aria-describedby=\"caption-attachment-942\" style=\"width: 555px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-medie-incasare.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-942\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-medie-incasare.png\" alt=\"Power Pivot - Pivot Table, rata medie incasare, sinteza pe asiguratori - Microsoft Excel 2013\" width=\"555\" height=\"228\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-medie-incasare.png 555w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-medie-incasare-300x123.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-medie-incasare-100x41.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-medie-incasare-150x62.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-medie-incasare-200x82.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-medie-incasare-450x185.png 450w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><\/a><figcaption id=\"caption-attachment-942\" class=\"wp-caption-text\"><strong>Power Pivot &#8211; Pivot Table, rata medie incasare, sinteza pe asiguratori &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p>Ce inseamna <strong>in context<\/strong>?<\/p>\n<p>Pai sa vedem ce se intampla daca in Pivot Table, inlocuim pe randuri asiguratorul cu regiunea accidentului.<\/p>\n<figure id=\"attachment_941\" aria-describedby=\"caption-attachment-941\" style=\"width: 555px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-medie-incasare-pe-regiuni.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-941\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-medie-incasare-pe-regiuni.png\" alt=\"Power Pivot - Pivot Table, sinteza pe regiuni - Microsoft Excel 2013\" width=\"555\" height=\"212\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-medie-incasare-pe-regiuni.png 555w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-medie-incasare-pe-regiuni-300x115.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-medie-incasare-pe-regiuni-100x38.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-medie-incasare-pe-regiuni-150x57.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-medie-incasare-pe-regiuni-200x76.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-medie-incasare-pe-regiuni-450x172.png 450w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><\/a><figcaption id=\"caption-attachment-941\" class=\"wp-caption-text\"><strong>Power Pivot &#8211; Pivot Table, sinteza pe regiuni &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p>Prin urmare, masura <strong>rata medie incasare<\/strong> recalculeaza de fiecare data valorile sintetice, in functie de felul in care este construit Pivot Table (ce avem pe randuri, respectiv coloane).<\/p>\n<ol start=\"2\">\n<li><span style=\"color: #800000;\"><strong>Valoare medie daune dosare nefinalizate\/ numar total dosare<\/strong><\/span><\/li>\n<\/ol>\n<p>Sa realizam o formula combinata, in care utilizam functia <span style=\"color: #800000;\"><a style=\"color: #800000;\" href=\"http:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-7-exemple-de-functii-dax-functia-calculate\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>CALCULATE<\/strong><\/a><\/span> si functia <strong>SUM.<\/strong><\/p>\n<p><strong>=calculate(sum(dosare[Valoare dauna calculata\/de platit (EUR)]),dosare[Status dosar]&lt;&gt;&#8221;finalizat&#8221;)\/sum(dosare[Valoare dauna calculata\/de platit (EUR)])<\/strong><\/p>\n<p><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-837 alignleft\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/semn-exclamare.gif\" alt=\"semn exclamare\" width=\"20\" height=\"30\" \/><\/a><\/p>\n<p><em>Nu conteaza daca scrieti denumirea functiilor cu majuscule sau nu!<\/em><\/p>\n<p>&nbsp;<\/p>\n<p>Observati mai intai felul in care am calculat valorile sintetice filtrate, adica totalul daunelor doar pentru dosarele nefinalizate.<\/p>\n<p>Impartim apoi rezultatul functiei CALCULATE la suma valorii daunelor calculate.<\/p>\n<p>Sa vedem rezultatul!<\/p>\n<figure id=\"attachment_940\" aria-describedby=\"caption-attachment-940\" style=\"width: 426px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-dosare-nefinalizate-calcul-contextual.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-940\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-dosare-nefinalizate-calcul-contextual.png\" alt=\"Power Pivot - Pivot Table, sinteza pe regiuni - Microsoft Excel 2013\" width=\"426\" height=\"241\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-dosare-nefinalizate-calcul-contextual.png 426w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-dosare-nefinalizate-calcul-contextual-300x170.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-dosare-nefinalizate-calcul-contextual-100x57.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-dosare-nefinalizate-calcul-contextual-150x85.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-dosare-nefinalizate-calcul-contextual-200x113.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-dosare-nefinalizate-calcul-contextual-128x72.png 128w\" sizes=\"auto, (max-width: 426px) 100vw, 426px\" \/><\/a><figcaption id=\"caption-attachment-940\" class=\"wp-caption-text\"><strong>Power Pivot &#8211; Pivot Table, sinteza pe regiuni &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p>La un calcul simplu, observati ca <strong>Grand Total<\/strong> (care reprezinta rata medie totala dosare nefinalizate, adica valoare totala daune dosare nefinalizate\/valoare totala daune dosare) nu corespunde cu suma valorilor din coloana respectiva.<\/p>\n<p>In fapt, campul calculat anterior realizeaza <strong>in context<\/strong> sinteza, adica imparte valoarea totala a daunelor pentru dosarele nefinalizate aferente fiecarui rand din sinteza (in cazul de mai sus, regiuni) la valoarea totala a daunelor pentru toate dosarele aferente fiecarui rand din sinteza.<\/p>\n<p>Cerinta exercitiului era <strong>insa<\/strong> ca impartirea sa se faca la valoarea totala a daunelor din tabela <strong>dosare<\/strong>, indiferent de context (adica de modul de sinteza a datelor).<\/p>\n<p>Pentru a exprima corect acest calcul, realizam un alt camp calculat, denumit <strong>%dosare nefinalizate (valoare % din total general)<\/strong>.<\/p>\n<p>Vom inscrie o formula usor diferita de cea anterioara, la numitor:<\/p>\n<p><strong>=CALCULATE(SUM(dosare[Valoare dauna calculata\/de platit (EUR)]),dosare[Status dosar]&lt;&gt;&#8221;finalizat&#8221;)\/CALCULATE(SUM(dosare[Valoare dauna calculata\/de platit (EUR)]),all(&#8216;dosare&#8217;))<\/strong><\/p>\n<p><span style=\"color: #800000;\">Prin urmare<\/span>,<\/p>\n<p><strong>sum(dosare[Valoare dauna calculata\/de platit (EUR)])<\/strong><\/p>\n<p>a devenit<\/p>\n<p><strong>CALCULATE(SUM(dosare[Valoare dauna calculata\/de platit (EUR)]),all(&#8216;dosare&#8217;))<\/strong><\/p>\n<p>, unde <strong>all(\u2018dosare\u2019)<\/strong>\u00a0&#8211; atentie la sintaxa! &#8211; reprezinta argumentul <strong>Filter1 <\/strong>al functiei <strong>CALCULATE<\/strong>.<\/p>\n<p>Aceasta formula va calcula totalul general, pentru toate articolele din tabela <strong>dosare<\/strong>.<\/p>\n<p>Tabelul sintetic de tip Pivot Table va arata acum astfel:<\/p>\n<figure id=\"attachment_939\" aria-describedby=\"caption-attachment-939\" style=\"width: 602px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-dosare-nefinalizate-calcul-TOTAL.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-939\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-dosare-nefinalizate-calcul-TOTAL.png\" alt=\"Power Pivot - Pivot Table, sinteza pe asiguratori - Microsoft Excel 2013\" width=\"602\" height=\"249\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-dosare-nefinalizate-calcul-TOTAL.png 602w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-dosare-nefinalizate-calcul-TOTAL-300x124.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-dosare-nefinalizate-calcul-TOTAL-100x41.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-dosare-nefinalizate-calcul-TOTAL-150x62.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-dosare-nefinalizate-calcul-TOTAL-200x83.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-dosare-nefinalizate-calcul-TOTAL-450x186.png 450w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-rata-dosare-nefinalizate-calcul-TOTAL-600x248.png 600w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/a><figcaption id=\"caption-attachment-939\" class=\"wp-caption-text\"><strong>Power Pivot &#8211; Pivot Table, sinteza pe asiguratori &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<ol start=\"3\">\n<li><span style=\"color: #800000;\"><strong>Numar mediu dosare nefinalizate\/ numar total dosare<\/strong><\/span><\/li>\n<\/ol>\n<p>Vrem acum sa calculam o rata procentuala care sa arate cat la suta reprezinta <strong>in context <\/strong>dosarele nefinalizate din total de dosare, de data aceasta ca numar de dosare, nu ca valoare a daunelor.<\/p>\n<p>Vom modifica putin formula anterioara, utilizand functia <strong>COUNT<\/strong> in loc de functia <strong>SUM<\/strong>.<\/p>\n<p>Am denumit aceasta masura calculata de utilizator <strong>rata dosare nefinalizate<\/strong>.<\/p>\n<p><strong>=CALCULATE(COUNT(dosare[Valoare dauna calculata\/de platit (EUR)]),dosare[Status dosar]&lt;&gt;&#8221;finalizat&#8221;)\/CALCULATE(COUNT(dosare[Valoare dauna calculata\/de platit (EUR)]),all(&#8216;dosare&#8217;))<\/strong><\/p>\n<p>Tabelul sintetic final (am mutat pe <strong>ROWS<\/strong> asiguratorii si am renuntat la campul <strong>Regiune accident<\/strong> din Pivot Table) va arata astfel:<\/p>\n<figure id=\"attachment_945\" aria-describedby=\"caption-attachment-945\" style=\"width: 680px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-sinteza-calculated-fields.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-945\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-sinteza-calculated-fields.png\" alt=\"Power Pivot - Pivot Table, sinteza finala pe asiguratori - Microsoft Excel 2013\" width=\"680\" height=\"268\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-sinteza-calculated-fields.png 680w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-sinteza-calculated-fields-300x118.png 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-sinteza-calculated-fields-100x39.png 100w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-sinteza-calculated-fields-150x59.png 150w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-sinteza-calculated-fields-200x79.png 200w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-sinteza-calculated-fields-450x177.png 450w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/08\/Power-BI_8_Pivot-Table-sinteza-calculated-fields-600x236.png 600w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/a><figcaption id=\"caption-attachment-945\" class=\"wp-caption-text\"><strong>Power Pivot &#8211; Pivot Table, sinteza finala pe asiguratori &#8211; Microsoft Excel 2013<\/strong><\/figcaption><\/figure>\n<p>Pentru o mai buna vizibilitate, am realizat o formatare conditionata simpla pentru a evidentia top 3 ccele mai mari rate ale dosarelor nefinalizate ca % din totalul daunelor calculate.<\/p>\n<p>Iata cum putem utiliza functia CALCULATE in combinatii complexe, pentru a realiza masuri (indicatori) sintetice relevante pentru analiza.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Incepand din 11 iulie 2016, vom publica in fiecare zi de luni si de joi cate un articol din seria de zece\u00a0cursuri gratuite dedicate Power Pivot pentru Excel 2013. ENJOY THE POWER! \ud83d\ude42 &nbsp; Se da un model de date, format din trei tabele, relationate astfel: Va aduceti aminte din articolele anterioare cum am creat [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":841,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[171],"tags":[189,976,188,176,170,166],"class_list":["post-946","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-pivot","tag-calculated-field","tag-cursuri-excel-online-gratuite","tag-functia-calculate","tag-model-de-date","tag-power-bi","tag-power-pivot"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"Incepand din 11 iulie 2016, vom publica in fiecare zi de luni si de joi cate un articol din seria de zece cursuri gratuite dedicate Power Pivot pentru Excel 2013. ENJOY THE POWER! :) Se da un model de date, format din trei tabele, relationate astfel: Va aduceti aminte din articolele anterioare cum am creat\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"-\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Power Pivot (8) \u2013 Exemple de functii DAX. Functia CALCULATE (2) -\" \/>\n\t\t<meta property=\"og:description\" content=\"Incepand din 11 iulie 2016, vom publica in fiecare zi de luni si de joi cate un articol din seria de zece cursuri gratuite dedicate Power Pivot pentru Excel 2013. ENJOY THE POWER! :) Se da un model de date, format din trei tabele, relationate astfel: Va aduceti aminte din articolele anterioare cum am creat\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-08-04T06:20:15+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-01-20T06:58:16+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Power Pivot (8) \u2013 Exemple de functii DAX. Functia CALCULATE (2) -\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Incepand din 11 iulie 2016, vom publica in fiecare zi de luni si de joi cate un articol din seria de zece cursuri gratuite dedicate Power Pivot pentru Excel 2013. ENJOY THE POWER! :) Se da un model de date, format din trei tabele, relationate astfel: Va aduceti aminte din articolele anterioare cum am creat\" \/>\n\t\t<meta name=\"twitter:image\" content=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\\\/#blogposting\",\"name\":\"Power Pivot (8) \\u2013 Exemple de functii DAX. Functia CALCULATE (2) -\",\"headline\":\"Power Pivot (8) &#8211; Exemple de functii DAX. Functia CALCULATE (2)\",\"author\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/Cursuri_gratuite_Excel.png\",\"width\":176,\"height\":178},\"datePublished\":\"2019-08-04T06:20:15+00:00\",\"dateModified\":\"2020-01-20T06:58:16+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\\\/#webpage\"},\"articleSection\":\"Power Pivot, Calculated field, cursuri excel online gratuite, functia CALCULATE, model de date, Power BI, Power Pivot\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/#listItem\",\"name\":\"Cursuri Excel\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/#listItem\",\"position\":2,\"name\":\"Cursuri Excel\",\"item\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/#listItem\",\"name\":\"Cursuri Excel gratuite\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/#listItem\",\"position\":3,\"name\":\"Cursuri Excel gratuite\",\"item\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/#listItem\",\"name\":\"Power Pivot\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/#listItem\",\"name\":\"Cursuri Excel\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/#listItem\",\"position\":4,\"name\":\"Power Pivot\",\"item\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\\\/#listItem\",\"name\":\"Power Pivot (8) &#8211; Exemple de functii DAX. Functia CALCULATE (2)\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/#listItem\",\"name\":\"Cursuri Excel gratuite\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\\\/#listItem\",\"position\":5,\"name\":\"Power Pivot (8) &#8211; Exemple de functii DAX. Functia CALCULATE (2)\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/#listItem\",\"name\":\"Power Pivot\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#organization\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/03\\\/SIGLA-BUNA-150x150.jpg\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\\\/#organizationLogo\",\"width\":150,\"height\":150},\"image\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\\\/#organizationLogo\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/#author\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\\\/#webpage\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\\\/\",\"name\":\"Power Pivot (8) \\u2013 Exemple de functii DAX. Functia CALCULATE (2) -\",\"description\":\"Incepand din 11 iulie 2016, vom publica in fiecare zi de luni si de joi cate un articol din seria de zece cursuri gratuite dedicate Power Pivot pentru Excel 2013. ENJOY THE POWER! :) Se da un model de date, format din trei tabele, relationate astfel: Va aduceti aminte din articolele anterioare cum am creat\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/Cursuri_gratuite_Excel.png\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\\\/#mainImage\",\"width\":176,\"height\":178},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/power-pivot\\\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\\\/#mainImage\"},\"datePublished\":\"2019-08-04T06:20:15+00:00\",\"dateModified\":\"2020-01-20T06:58:16+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Power Pivot (8) \u2013 Exemple de functii DAX. Functia CALCULATE (2) -","description":"Incepand din 11 iulie 2016, vom publica in fiecare zi de luni si de joi cate un articol din seria de zece cursuri gratuite dedicate Power Pivot pentru Excel 2013. ENJOY THE POWER! :) Se da un model de date, format din trei tabele, relationate astfel: Va aduceti aminte din articolele anterioare cum am creat","canonical_url":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\/#blogposting","name":"Power Pivot (8) \u2013 Exemple de functii DAX. Functia CALCULATE (2) -","headline":"Power Pivot (8) &#8211; Exemple de functii DAX. Functia CALCULATE (2)","author":{"@id":"https:\/\/eticsolutions.ro\/blog\/author\/#author"},"publisher":{"@id":"https:\/\/eticsolutions.ro\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Cursuri_gratuite_Excel.png","width":176,"height":178},"datePublished":"2019-08-04T06:20:15+00:00","dateModified":"2020-01-20T06:58:16+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\/#webpage"},"isPartOf":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\/#webpage"},"articleSection":"Power Pivot, Calculated field, cursuri excel online gratuite, functia CALCULATE, model de date, Power BI, Power Pivot"},{"@type":"BreadcrumbList","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog#listItem","position":1,"name":"Home","item":"https:\/\/eticsolutions.ro\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/#listItem","name":"Cursuri Excel"}},{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/#listItem","position":2,"name":"Cursuri Excel","item":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/","nextItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/#listItem","name":"Cursuri Excel gratuite"},"previousItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/#listItem","position":3,"name":"Cursuri Excel gratuite","item":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/","nextItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/#listItem","name":"Power Pivot"},"previousItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/#listItem","name":"Cursuri Excel"}},{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/#listItem","position":4,"name":"Power Pivot","item":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/","nextItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\/#listItem","name":"Power Pivot (8) &#8211; Exemple de functii DAX. Functia CALCULATE (2)"},"previousItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/#listItem","name":"Cursuri Excel gratuite"}},{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\/#listItem","position":5,"name":"Power Pivot (8) &#8211; Exemple de functii DAX. Functia CALCULATE (2)","previousItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/#listItem","name":"Power Pivot"}}]},{"@type":"Organization","@id":"https:\/\/eticsolutions.ro\/blog\/#organization","url":"https:\/\/eticsolutions.ro\/blog\/","logo":{"@type":"ImageObject","url":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\/#organizationLogo","width":150,"height":150},"image":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\/#organizationLogo"}},{"@type":"Person","@id":"https:\/\/eticsolutions.ro\/blog\/author\/#author","url":"https:\/\/eticsolutions.ro\/blog\/author\/"},{"@type":"WebPage","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\/#webpage","url":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\/","name":"Power Pivot (8) \u2013 Exemple de functii DAX. Functia CALCULATE (2) -","description":"Incepand din 11 iulie 2016, vom publica in fiecare zi de luni si de joi cate un articol din seria de zece cursuri gratuite dedicate Power Pivot pentru Excel 2013. ENJOY THE POWER! :) Se da un model de date, format din trei tabele, relationate astfel: Va aduceti aminte din articolele anterioare cum am creat","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/eticsolutions.ro\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\/#breadcrumblist"},"author":{"@id":"https:\/\/eticsolutions.ro\/blog\/author\/#author"},"creator":{"@id":"https:\/\/eticsolutions.ro\/blog\/author\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2016\/07\/Cursuri_gratuite_Excel.png","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\/#mainImage","width":176,"height":178},"primaryImageOfPage":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\/#mainImage"},"datePublished":"2019-08-04T06:20:15+00:00","dateModified":"2020-01-20T06:58:16+00:00"},{"@type":"WebSite","@id":"https:\/\/eticsolutions.ro\/blog\/#website","url":"https:\/\/eticsolutions.ro\/blog\/","inLanguage":"en-US","publisher":{"@id":"https:\/\/eticsolutions.ro\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"-","og:type":"article","og:title":"Power Pivot (8) \u2013 Exemple de functii DAX. Functia CALCULATE (2) -","og:description":"Incepand din 11 iulie 2016, vom publica in fiecare zi de luni si de joi cate un articol din seria de zece cursuri gratuite dedicate Power Pivot pentru Excel 2013. ENJOY THE POWER! :) Se da un model de date, format din trei tabele, relationate astfel: Va aduceti aminte din articolele anterioare cum am creat","og:url":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\/","og:image":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg","og:image:secure_url":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg","article:published_time":"2019-08-04T06:20:15+00:00","article:modified_time":"2020-01-20T06:58:16+00:00","twitter:card":"summary_large_image","twitter:title":"Power Pivot (8) \u2013 Exemple de functii DAX. Functia CALCULATE (2) -","twitter:description":"Incepand din 11 iulie 2016, vom publica in fiecare zi de luni si de joi cate un articol din seria de zece cursuri gratuite dedicate Power Pivot pentru Excel 2013. ENJOY THE POWER! :) Se da un model de date, format din trei tabele, relationate astfel: Va aduceti aminte din articolele anterioare cum am creat","twitter:image":"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg"},"aioseo_meta_data":{"post_id":"946","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":null,"og_image_width":null,"og_image_height":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"created":"2026-06-29 09:51:21","updated":"2026-06-29 09:51:21"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/eticsolutions.ro\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/\" title=\"Cursuri Excel\">Cursuri Excel<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/\" title=\"Cursuri Excel gratuite\">Cursuri Excel gratuite<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/\" title=\"Power Pivot\">Power Pivot<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tPower Pivot (8) \u2013 Exemple de functii DAX. Functia CALCULATE (2)\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/eticsolutions.ro\/blog"},{"label":"Cursuri Excel","link":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/"},{"label":"Cursuri Excel gratuite","link":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/"},{"label":"Power Pivot","link":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/"},{"label":"Power Pivot (8) &#8211; Exemple de functii DAX. Functia CALCULATE (2)","link":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/power-pivot\/power-pivot-8-exemple-de-functii-dax-functia-calculate-2\/"}],"_links":{"self":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts\/946","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/comments?post=946"}],"version-history":[{"count":3,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts\/946\/revisions"}],"predecessor-version":[{"id":3351,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts\/946\/revisions\/3351"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/media\/841"}],"wp:attachment":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/media?parent=946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/categories?post=946"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/tags?post=946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}