{"id":5692,"date":"2022-02-25T06:00:22","date_gmt":"2022-02-25T05:00:22","guid":{"rendered":"https:\/\/bestdatasolutions.es\/?p=5692"},"modified":"2022-06-21T11:55:26","modified_gmt":"2022-06-21T10:55:26","slug":"calculation-groups-on-powerbi","status":"publish","type":"post","link":"https:\/\/bestdatasolutions.es\/en\/blog\/calculation-groups-on-powerbi\/","title":{"rendered":"Calculation Groups on Power BI"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"5692\" class=\"elementor elementor-5692 elementor-5691\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d32b5ac elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"d32b5ac\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c1dc6d3\" data-id=\"c1dc6d3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-911012a elementor-widget elementor-widget-theme-post-featured-image elementor-widget-image\" data-id=\"911012a\" data-element_type=\"widget\" data-widget_type=\"theme-post-featured-image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1920\" height=\"500\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/powerbi-calculation-groups.jpg\" class=\"attachment-full size-full wp-image-6577\" alt=\"powerbi-calculation-groups\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/powerbi-calculation-groups.jpg 1920w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/powerbi-calculation-groups-300x78.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/powerbi-calculation-groups-1024x267.jpg 1024w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/powerbi-calculation-groups-768x200.jpg 768w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/powerbi-calculation-groups-1536x400.jpg 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5d1c2c13 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5d1c2c13\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-5aae2e0d\" data-id=\"5aae2e0d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1a3ffa42 elementor-author-box--layout-image-left elementor-author-box--align-left elementor-author-box--image-valign-middle elementor-author-box--avatar-yes elementor-author-box--name-yes elementor-author-box--biography-yes elementor-widget elementor-widget-author-box\" data-id=\"1a3ffa42\" data-element_type=\"widget\" data-widget_type=\"author-box.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-author-box\">\n\t\t\t\t\t\t\t<a href=\"https:\/\/www.linkedin.com\/in\/laura-vilaseca-corominas-6671b066\/\" target=\"_blank\" class=\"elementor-author-box__avatar\" rel=\"noopener\">\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/avatar_user_9_1643811270.jpg\" alt=\"Picture of Laura Vilaseca\" loading=\"lazy\" title=\"\">\n\t\t\t\t<\/a>\n\t\t\t\n\t\t\t<div class=\"elementor-author-box__text\">\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.linkedin.com\/in\/laura-vilaseca-corominas-6671b066\/\" target=\"_blank\" rel=\"noopener\">\n\t\t\t\t\t\t<h4 class=\"elementor-author-box__name\">\n\t\t\t\t\t\t\tLaura Vilaseca\t\t\t\t\t\t<\/h4>\n\t\t\t\t\t<\/a>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-author-box__bio\">\n\t\t\t\t\t\tBusiness Intelligence Consultant | Data Specialist\t\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-41a959e0 elementor-widget elementor-widget-heading\" data-id=\"41a959e0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-large\">Other Articles:<\/h3>\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-6c75b22c\" data-id=\"6c75b22c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5795bde9 elementor-widget elementor-widget-theme-post-title elementor-page-title elementor-widget-heading\" data-id=\"5795bde9\" data-element_type=\"widget\" data-widget_type=\"theme-post-title.default\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-xl\">Calculation Groups on Power BI<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-561b31d1 elementor-widget elementor-widget-post-info\" data-id=\"561b31d1\" data-element_type=\"widget\" data-widget_type=\"post-info.default\">\n\t\t\t\t\t\t\t<ul class=\"elementor-inline-items elementor-icon-list-items elementor-post-info\">\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-repeater-item-869d2fb elementor-inline-item\" itemprop=\"datePublished\">\n\t\t\t\t\t\t<a href=\"https:\/\/bestdatasolutions.es\/en\/2022\/02\/25\/\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-calendar\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M12 192h424c6.6 0 12 5.4 12 12v260c0 26.5-21.5 48-48 48H48c-26.5 0-48-21.5-48-48V204c0-6.6 5.4-12 12-12zm436-44v-36c0-26.5-21.5-48-48-48h-48V12c0-6.6-5.4-12-12-12h-40c-6.6 0-12 5.4-12 12v52H160V12c0-6.6-5.4-12-12-12h-40c-6.6 0-12 5.4-12 12v52H48C21.5 64 0 85.5 0 112v36c0 6.6 5.4 12 12 12h424c6.6 0 12-5.4 12-12z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text elementor-post-info__item elementor-post-info__item--type-date\">\n\t\t\t\t\t\t\t\t\t\t<time>25\/02\/2022<\/time>\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/li>\n\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7476169 elementor-share-buttons--view-icon-text elementor-share-buttons--skin-gradient elementor-share-buttons--shape-square elementor-grid-0 elementor-share-buttons--color-official elementor-widget elementor-widget-share-buttons\" data-id=\"7476169\" data-element_type=\"widget\" data-widget_type=\"share-buttons.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-grid\" role=\"list\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_linkedin\" role=\"button\" tabindex=\"0\" aria-label=\"Share on linkedin\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-linkedin\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 32H31.9C14.3 32 0 46.5 0 64.3v383.4C0 465.5 14.3 480 31.9 480H416c17.6 0 32-14.5 32-32.3V64.3c0-17.8-14.4-32.3-32-32.3zM135.4 416H69V202.2h66.5V416zm-33.2-243c-21.3 0-38.5-17.3-38.5-38.5S80.9 96 102.2 96c21.2 0 38.5 17.3 38.5 38.5 0 21.3-17.2 38.5-38.5 38.5zm282.1 243h-66.4V312c0-24.8-.5-56.7-34.5-56.7-34.6 0-39.9 27-39.9 54.9V416h-66.4V202.2h63.7v29.2h.9c8.9-16.8 30.6-34.5 62.9-34.5 67.2 0 79.7 44.3 79.7 101.9V416z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tLinkedIn\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_facebook\" role=\"button\" tabindex=\"0\" aria-label=\"Share on facebook\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-facebook\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M504 256C504 119 393 8 256 8S8 119 8 256c0 123.78 90.69 226.38 209.25 245V327.69h-63V256h63v-54.64c0-62.15 37-96.48 93.67-96.48 27.14 0 55.52 4.84 55.52 4.84v61h-31.28c-30.8 0-40.41 19.12-40.41 38.73V256h68.78l-11 71.69h-57.78V501C413.31 482.38 504 379.78 504 256z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tFacebook\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_twitter\" role=\"button\" tabindex=\"0\" aria-label=\"Share on twitter\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-twitter\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M459.37 151.716c.325 4.548.325 9.097.325 13.645 0 138.72-105.583 298.558-298.558 298.558-59.452 0-114.68-17.219-161.137-47.106 8.447.974 16.568 1.299 25.34 1.299 49.055 0 94.213-16.568 130.274-44.832-46.132-.975-84.792-31.188-98.112-72.772 6.498.974 12.995 1.624 19.818 1.624 9.421 0 18.843-1.3 27.614-3.573-48.081-9.747-84.143-51.98-84.143-102.985v-1.299c13.969 7.797 30.214 12.67 47.431 13.319-28.264-18.843-46.781-51.005-46.781-87.391 0-19.492 5.197-37.36 14.294-52.954 51.655 63.675 129.3 105.258 216.365 109.807-1.624-7.797-2.599-15.918-2.599-24.04 0-57.828 46.782-104.934 104.934-104.934 30.213 0 57.502 12.67 76.67 33.137 23.715-4.548 46.456-13.32 66.599-25.34-7.798 24.366-24.366 44.833-46.132 57.827 21.117-2.273 41.584-8.122 60.426-16.243-14.292 20.791-32.161 39.308-52.628 54.253z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tTwitter\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_whatsapp\" role=\"button\" tabindex=\"0\" aria-label=\"Share on whatsapp\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-whatsapp\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M380.9 97.1C339 55.1 283.2 32 223.9 32c-122.4 0-222 99.6-222 222 0 39.1 10.2 77.3 29.6 111L0 480l117.7-30.9c32.4 17.7 68.9 27 106.1 27h.1c122.3 0 224.1-99.6 224.1-222 0-59.3-25.2-115-67.1-157zm-157 341.6c-33.2 0-65.7-8.9-94-25.7l-6.7-4-69.8 18.3L72 359.2l-4.4-7c-18.5-29.4-28.2-63.3-28.2-98.2 0-101.7 82.8-184.5 184.6-184.5 49.3 0 95.6 19.2 130.4 54.1 34.8 34.9 56.2 81.2 56.1 130.5 0 101.8-84.9 184.6-186.6 184.6zm101.2-138.2c-5.5-2.8-32.8-16.2-37.9-18-5.1-1.9-8.8-2.8-12.5 2.8-3.7 5.6-14.3 18-17.6 21.8-3.2 3.7-6.5 4.2-12 1.4-32.6-16.3-54-29.1-75.5-66-5.7-9.8 5.7-9.1 16.3-30.3 1.8-3.7.9-6.9-.5-9.7-1.4-2.8-12.5-30.1-17.1-41.2-4.5-10.8-9.1-9.3-12.5-9.5-3.2-.2-6.9-.2-10.6-.2-3.7 0-9.7 1.4-14.8 6.9-5.1 5.6-19.4 19-19.4 46.3 0 27.3 19.9 53.7 22.6 57.4 2.8 3.7 39.1 59.7 94.8 83.8 35.2 15.2 49 16.5 66.6 13.9 10.7-1.6 32.8-13.4 37.4-26.4 4.6-13 4.6-24.1 3.2-26.4-1.3-2.5-5-3.9-10.5-6.6z\"><\/path><\/svg>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tWhatsApp\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-56263e9 elementor-widget elementor-widget-text-editor\" data-id=\"56263e9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>This article is an introduction to Calculation Groups in Power BI in which we will see what they are, how they are developed, and when to use them.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e3e390c elementor-widget elementor-widget-heading\" data-id=\"e3e390c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">What is it?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ef5cc8b elementor-widget elementor-widget-text-editor\" data-id=\"ef5cc8b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>To use Tabular Editor we go to their <a href=\"https:\/\/tabulareditor.com\/downloads\" target=\"_blank\" rel=\"noopener\">website<\/a> to download this application. There are different versions, the commercial (Tabular Editor 3) and the free one (Tabular Editor 2) and choose the one we are most interested in. Once downloaded, in the <i>pbix<\/i> of the report we are working on, we will have this tool in the External tools tab ready to use it.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3f016a2 elementor-widget elementor-widget-image\" data-id=\"3f016a2\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"210\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155449-1.jpg\" class=\"attachment-large size-large wp-image-5703\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155449-1.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155449-1-300x79.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155449-1-768x202.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e63ea58 elementor-widget elementor-widget-text-editor\" data-id=\"e63ea58\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>In this tutorial, we are working with product sales data and we want to analyze them in different time periods (YTD, MoM and Last Year). But if we want to analyze also the cost and the total quantity, we will have to create 3 measures per KPI, i.e. we have to create 9 measures for this analysis. With the Calculation Groups, we can reduce the number of measurements we have in the report by centralizing the formula in the Calculation Groups.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6a8390a elementor-widget elementor-widget-text-editor\" data-id=\"6a8390a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>First, we open Tabular Editor from the report we have open. This connects directly to the tabular model and we can start working.<\/p><p>To create a Calculation Group we have to go to <i>Model -&gt; New Calculation Group.<\/i> In the right panel, a new element will appear which is the CG. To start creating measurements, we have to deploy it, right-click on the Calculation Items folder, and create a new one.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3be96e7 elementor-widget elementor-widget-image\" data-id=\"3be96e7\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"440\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155519-1.jpg\" class=\"attachment-large size-large wp-image-5705\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155519-1.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155519-1-300x165.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155519-1-768x422.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e752c91 elementor-widget elementor-widget-image\" data-id=\"e752c91\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"422\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155600-1.jpg\" class=\"attachment-large size-large wp-image-5707\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155600-1.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155600-1-300x158.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155600-1-768x405.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-23f4a3d elementor-widget elementor-widget-text-editor\" data-id=\"23f4a3d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>On the main screen, Expression Editor is where we are going to write the formula we need in DAX.<\/p><p>As mentioned above, we want to calculate YTD, MoM and LY of sales, cost and sales quantity. To only write these 3 measures we have to use the <i>SELECTEDMEASURE()<\/i> function, since it returns the measure being evaluated, and therefore we get the dynamism we are looking for.<\/p><p>This is how the calculation items would look like:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c7cf36e elementor-widget elementor-widget-image\" data-id=\"c7cf36e\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"321\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155629-1.jpg\" class=\"attachment-large size-large wp-image-5709\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155629-1.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155629-1-300x120.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155629-1-768x308.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-45b9189 elementor-widget elementor-widget-image\" data-id=\"45b9189\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"289\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155659-1.jpg\" class=\"attachment-large size-large wp-image-5711\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155659-1.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155659-1-300x108.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155659-1-768x277.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-37690e2 elementor-widget elementor-widget-image\" data-id=\"37690e2\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"297\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155717-1.jpg\" class=\"attachment-large size-large wp-image-5713\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155717-1.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155717-1-300x111.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155717-1-768x285.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b0118df elementor-widget elementor-widget-image\" data-id=\"b0118df\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"352\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155755-1.jpg\" class=\"attachment-large size-large wp-image-5715\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155755-1.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155755-1-300x132.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155755-1-768x338.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4e0bf8c elementor-widget elementor-widget-text-editor\" data-id=\"4e0bf8c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>In addition to creating the three time-based measures, we have added &#8220;Actual&#8221; to have the measure that returns the value of each KPI without time filters.<\/p><p>Once this development is saved, we go to pbix and click on<i> refresh now<\/i> button that appears in a yellow strip. <\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-44b3486 elementor-widget elementor-widget-image\" data-id=\"44b3486\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"311\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155815-1.jpg\" class=\"attachment-large size-large wp-image-5717\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155815-1.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155815-1-300x117.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155815-1-768x299.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f073712 elementor-widget elementor-widget-text-editor\" data-id=\"f073712\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>We see that the Calculation Group has been loaded as a table with the following appearance:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e16c831 elementor-widget elementor-widget-image\" data-id=\"e16c831\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"417\" height=\"372\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155830-1.jpg\" class=\"attachment-large size-large wp-image-5719\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155830-1.jpg 417w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155830-1-300x268.jpg 300w\" sizes=\"(max-width: 417px) 100vw, 417px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a8ba684 elementor-widget elementor-widget-text-editor\" data-id=\"a8ba684\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>To use this element we have to combine the GC field with the previously calculated KPIs (Sales Amount, Sales Cost, and Sales Quantity). For example, we can create a matrix using the <i>name<\/i> of the calculation group as the row field, and add the 3 measures we have created in the value field, so we see in the same visual the three KPIs analyzed in different time periods.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6e83af2 elementor-widget elementor-widget-image\" data-id=\"6e83af2\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"333\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155851-1.jpg\" class=\"attachment-large size-large wp-image-5721\" alt=\"\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155851-1.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155851-1-300x125.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155851-1-768x320.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-82d70fd elementor-widget elementor-widget-text-editor\" data-id=\"82d70fd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Also, we can build a <i>slicer<\/i> with the calculation items to filter the visuals with the type of temporal analysis we want to do. We have built two <i>bar charts<\/i>, the one above with the KPIs of total sales and total cost per year, and the second one analyzing the total amount of products sold per month and year. If we click on MoM, we see how the <i>Sales quantity by date<\/i> visual has changed and now shows the monthly growth of the quantity sold.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7260f18 elementor-widget elementor-widget-image\" data-id=\"7260f18\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"459\" src=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155909-1.jpg\" class=\"attachment-large size-large wp-image-5723\" alt=\"Calculation Group Example 2\" srcset=\"https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155909-1.jpg 800w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155909-1-300x172.jpg 300w, https:\/\/bestdatasolutions.es\/wp-content\/uploads\/Captura-de-pantalla-2022-02-24-155909-1-768x441.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4869121 elementor-widget elementor-widget-text-editor\" data-id=\"4869121\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>To conclude, we can say that the Calculation Groups help to optimize the development and maintenance of the necessary measures in a report. In addition to this type of approach, you can create custom groupings, groups of KPIs with different formats (sales vs. margin %), and more.<\/p><p>With creativity, you can create impressive developments!&nbsp;<\/p><p>I hope you enjoyed it.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-614b2ec9 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"614b2ec9\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c77df54 elementor-align-center elementor-widget elementor-widget-button\" data-id=\"c77df54\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/bestdatasolutions.es\/en\/blog\/\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">&lt;&lt; BACK TO BLOG<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Calculation Groups are a grouping of calculation items, which are expressions of common measurements, such as those we write in the report. Therefore, it is a grouping of measures. To create and edit Calculations Groups, we need the Tabular Editor, an external Power BI tool.<\/p>\n","protected":false},"author":9,"featured_media":6577,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[75],"class_list":["post-5692","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-powerbi-en"],"_links":{"self":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/5692","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/comments?post=5692"}],"version-history":[{"count":0,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/posts\/5692\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media\/6577"}],"wp:attachment":[{"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/media?parent=5692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/categories?post=5692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bestdatasolutions.es\/en\/wp-json\/wp\/v2\/tags?post=5692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}