{"id":176604,"date":"2024-01-16T21:03:50","date_gmt":"2024-01-16T20:03:50","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=176604"},"modified":"2024-01-16T21:09:07","modified_gmt":"2024-01-16T20:09:07","slug":"all-you-need-to-know-about-the-power-bi-calculate-function","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/all-you-need-to-know-about-the-power-bi-calculate-function","title":{"rendered":"All you need to know about the Power BI CALCULATE function"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"176604\" class=\"elementor elementor-176604\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0574a56 e-flex e-con-boxed e-con\" data-id=\"0574a56\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2a99d1b elementor-widget elementor-widget-text-editor\" data-id=\"2a99d1b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<h2>Visual Analytics is the union of data analysis and visualizations. This problem-solving approach aims to facilitate complex, high-level activities such as reasoning and data-driven decision-making, for example with he Power BI Calculate function. All this by integrating interactive visual representations with the underlying analytical processes.<\/h2>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f0b15c0 elementor-widget elementor-widget-text-editor\" data-id=\"f0b15c0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><a href=\"https:\/\/datascientest.com\/en\/introduction-to-business-intelligence\"><strong>Power BI is a Business Intelligence (BI) tool<\/strong> <\/a>and Visual Analytics engine from Microsoft that provides high-level, real-time analysis, extensive modeling and customized development. It has led the way in making business analysis more efficient through intuitive, interactive and easy-to-use services.<\/p><p>In this article, you&#8217;ll learn about<strong> Power BI CALCULATE function<\/strong> in Power BI. You&#8217;ll also gain an overall understanding of Power BI, its key features, <a href=\"https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions\">DAX functions in Power BI<\/a> and how to use the CALCULATE function in Power BI. Read on for detailed information on Power BI&#8217;s CALCULATE function.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-417f3d3 elementor-widget__width-initial elementor-widget elementor-widget-video\" data-id=\"417f3d3\" data-element_type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/youtu.be\\\/lEbGFwwjfhg&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-video .elementor-widget-container{overflow:hidden;transform:translateZ(0)}.elementor-widget-video .elementor-wrapper{aspect-ratio:var(--video-aspect-ratio)}.elementor-widget-video .elementor-wrapper iframe,.elementor-widget-video .elementor-wrapper video{height:100%;width:100%;display:flex;border:none;background-color:#000}@supports not (aspect-ratio:1\/1){.elementor-widget-video .elementor-wrapper{position:relative;overflow:hidden;height:0;padding-bottom:calc(100% \/ var(--video-aspect-ratio))}.elementor-widget-video .elementor-wrapper iframe,.elementor-widget-video .elementor-wrapper video{position:absolute;top:0;right:0;bottom:0;left:0}}.elementor-widget-video .elementor-open-inline .elementor-custom-embed-image-overlay{position:absolute;top:0;right:0;bottom:0;left:0;background-size:cover;background-position:50%}.elementor-widget-video .elementor-custom-embed-image-overlay{cursor:pointer;text-align:center}.elementor-widget-video .elementor-custom-embed-image-overlay:hover .elementor-custom-embed-play i{opacity:1}.elementor-widget-video .elementor-custom-embed-image-overlay img{display:block;width:100%;aspect-ratio:var(--video-aspect-ratio);-o-object-fit:cover;object-fit:cover;-o-object-position:center center;object-position:center center}@supports not (aspect-ratio:1\/1){.elementor-widget-video .elementor-custom-embed-image-overlay{position:relative;overflow:hidden;height:0;padding-bottom:calc(100% \/ var(--video-aspect-ratio))}.elementor-widget-video .elementor-custom-embed-image-overlay img{position:absolute;top:0;right:0;bottom:0;left:0}}.elementor-widget-video .e-hosted-video .elementor-video{-o-object-fit:cover;object-fit:cover}.e-con-inner>.elementor-widget-video,.e-con>.elementor-widget-video{width:var(--container-widget-width);--flex-grow:var(--container-widget-flex-grow)}<\/style>\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e3a9854 e-flex e-con-boxed e-con\" data-id=\"e3a9854\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e5b1b8d elementor-widget elementor-widget-heading\" data-id=\"e5b1b8d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h3 class=\"elementor-heading-title elementor-size-default\">What is Power BI?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a0c6302 elementor-widget elementor-widget-text-editor\" data-id=\"a0c6302\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Power BI<\/strong> is part of the Microsoft Power Platform, a <a href=\"https:\/\/datascientest.com\/en\/dataviz-definition-objectives-and-uses\">proprietary data visualization<\/a> and business intelligence platform. It is one of the most widely used tools by organizations to <strong>analyze business data<\/strong> and generate real-time reports.<\/p><p><strong>Power BI<\/strong> uses a collection of various integrated software services, applications and connectors to deeply integrate with data to provide immersive visuals, interactive reports and insight generation.<\/p><p><a href=\"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases\">Power BI helps users aggregate<\/a>, analyze, visualize and share data. It is a SaaS (software as a service) platform and is also available for desktop, mobile and on-premise servers. Power BI supports connection with numerous data source connectors to load data into the dashboard directly from the data source, and visualize data stored in databases or data warehouses. Users can use Power BI charts, graphs, <a href=\"https:\/\/datascientest.com\/en\/our-guide-to-power-bi-kpi-definition-and-purpose\">KPIs and reports to analyze data<\/a> and obtain interactive information.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-77133b6 e-flex e-con-boxed e-con\" data-id=\"77133b6\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c98d185 elementor-widget elementor-widget-heading\" data-id=\"c98d185\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What are DAX functions in Power BI?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e2a2857 elementor-widget elementor-widget-text-editor\" data-id=\"e2a2857\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><a href=\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language\">Data Analysis Expressions (DAX)<\/a> are a set of functions and operators that can be used to create formulas and expressions in Microsoft SQL Server Analysis Services, Excel Power Pivot and <a href=\"https:\/\/datascientest.com\/en\/power-bi-desktop-download-and-installation-guide\">Power BI Desktop<\/a>. A DAX function is a predefined formula that performs calculations on the values passed to it as arguments.<\/p><p>The arguments to a function must be in a particular order and can be a column reference, numbers, text, constants, another formula or function, or a logical value such as TRUE or FALSE. Each function performs a particular operation on the values contained in an argument. You can use several arguments in a DAX formula.<\/p><p>Some of the <strong>Power BI DAX functions<\/strong> are :<\/p><ul><li><a href=\"https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions\"><strong>Time intelligence functions<\/strong>:<\/a> these functions help you create calculations that use built-in calendar and date knowledge. You can perform sales, inventory and other meaningful comparisons over similar time periods by combining time and date ranges with aggregations or other calculations.<\/li><li><a href=\"https:\/\/datascientest.com\/en\/mastering-power-bi-datediff-effortlessly-calculate-time-intervals\"><strong>Date and time functions:<\/strong><\/a> used to perform calculations on date and time values.<\/li><li><strong>Logic functions:<\/strong> these are used to logically evaluate an expression or argument, and return TRUE or FALSE depending on whether the condition is met or not.<\/li><li><strong>Mathematical and trigonometric functions<\/strong>: used to perform various mathematical operations on specified values<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-219c401 elementor-widget elementor-widget-image\" data-id=\"219c401\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/03\/power-bi-dax.jpg\" title=\"\" alt=\"power-bi-dax\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8b7fa60 e-flex e-con-boxed e-con\" data-id=\"8b7fa60\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a76b6a8 elementor-widget elementor-widget-heading\" data-id=\"a76b6a8\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What is Power BI's CALCULATE function?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-603b469 elementor-widget elementor-widget-text-editor\" data-id=\"603b469\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>One of the most dynamic functions that can help you add more in-depth information to your reports is the CALCULATE function. The <strong>Power BI CALCULATE function<\/strong> lets you change the context of a calculation within a measurement, the context being determined by the environment in which the calculation is performed.<\/p><p>Using the <strong>Power BI CALCULATE function<\/strong>, you can easily move on to time-intelligent calculations. You can generate high-quality information in <strong>Power BI using Power BI&#8217;s calculation functions.<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-811ec48 elementor-widget elementor-widget-heading\" data-id=\"811ec48\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Basic syntax<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0d045dd elementor-widget elementor-widget-text-editor\" data-id=\"0d045dd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The <strong>DAX syntax of Power BI&#8217;s<\/strong> CALCULATE function is as follows:<\/p><p>CALCULATE (&lt;[expression]&gt;,[[filter1],([filter2],([filter&#8230;]))))<\/p><p>The syntax of the Power BI CALCULATE function can be broken down into two parts:<\/p><ul><li><strong>Aggregation:<\/strong> the first part of the expression is the aggregation part. This is where you can place any aggregation function you like, whether SUM of sales, total sales, AVG Price (average price) or something else.<\/li><li><strong>Filter:<\/strong> the second part corresponds to your filter criteria. This part defines the data set to which you apply the aggregation in the first part.<\/li><\/ul><p>Filters can be any of the following:<\/p><ul><li>Boolean filter expressions<\/li><li>Table filter expressions<br \/>Filter modification functions<\/li><\/ul><p>Of course, using the <strong>Power BI CALCULATE<\/strong> function covers several use cases, some of which are as follows:<\/p><ul><li>Single filter criteria<\/li><li>Multiple filter criteria<\/li><li>Using the FILTER function<\/li><li>Use of the ALL function<\/li><li>Use of the <a href=\"https:\/\/datascientest.com\/en\/the-power-bi-allexcept-function\">ALLEXCEPT function<\/a><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-aa206b3 e-flex e-con-boxed e-con\" data-id=\"aa206b3\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e5a6332 elementor-widget elementor-widget-heading\" data-id=\"e5a6332\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comments<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a890439 elementor-widget elementor-widget-text-editor\" data-id=\"a890439\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>When using the <strong>Power BI CALCULATE<\/strong> function, you may encounter a few hazards which you can do something about. You just need to know what they are. Here they are:<\/p><ul><li>When filter expressions are passed to Power BI&#8217;s CALCULATE function, the filter context is modified to evaluate the expression.<\/li><li>When the filter expression is not encapsulated in the KEEPFILTERS function, there are two possible standard results:<\/li><li>New filters will be added if the columns (or tables) are not in the filter context. this allows the Power BI calculation function expression to be evaluated.<\/li><li>New filters will replace existing filters if the columns (or tables) are already in the filter context. In this way, it is possible to evaluate the expression.<\/li><li><strong>Power BI CALCULATE function<\/strong> meets a specific requirement when used without filters. It changes the row context into the filter context.<br \/>When an expression that summarizes model data is to be evaluated in a line context, it is mandatory.<\/li><li>This occurs, for example, in a calculated column formula or when evaluating an expression in an iteration function. Note that when a model measure is used in a row context, the context transition occurs automatically.<\/li><li>When used in calculated columns or row-level safety rules (RLS), Power BI&#8217;s CALCULATE function is not supported in Direct Query mode.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9a6955a elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"9a6955a\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn the CALCULATE function with Power BI training<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Visual Analytics is the union of data analysis and visualizations. This problem-solving approach aims to facilitate complex, high-level activities such as reasoning and data-driven decision-making, for example with he Power BI Calculate function. All this by integrating interactive visual representations with the underlying analytical processes. Power BI is a Business Intelligence (BI) tool and Visual [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":176606,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>All you need to know about the Power BI CALCULATE function<\/title>\n<meta name=\"description\" content=\"When using the Power BI CALCULATE function, as a professional should be aware about the fact that the function is..K.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/all-you-need-to-know-about-the-power-bi-calculate-function\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"All you need to know about the Power BI CALCULATE function\" \/>\n<meta property=\"og:description\" content=\"Visual Analytics is the union of data analysis and visualizations. This problem-solving approach aims to facilitate complex, high-level activities such as\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/all-you-need-to-know-about-the-power-bi-calculate-function\" \/>\n<meta property=\"og:site_name\" content=\"DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-16T20:03:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-16T20:09:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/01\/power-bi-calculate-funktion.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"421\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/all-you-need-to-know-about-the-power-bi-calculate-function#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/all-you-need-to-know-about-the-power-bi-calculate-function\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"All you need to know about the Power BI CALCULATE function\",\"datePublished\":\"2024-01-16T20:03:50+00:00\",\"dateModified\":\"2024-01-16T20:09:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/all-you-need-to-know-about-the-power-bi-calculate-function\"},\"wordCount\":961,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/all-you-need-to-know-about-the-power-bi-calculate-function#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/all-you-need-to-know-about-the-power-bi-calculate-function\",\"url\":\"https:\/\/datascientest.com\/en\/all-you-need-to-know-about-the-power-bi-calculate-function\",\"name\":\"All you need to know about the Power BI CALCULATE function\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-01-16T20:03:50+00:00\",\"dateModified\":\"2024-01-16T20:09:07+00:00\",\"description\":\"When using the Power BI CALCULATE function, as a professional should be aware about the fact that the function is..K.\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/all-you-need-to-know-about-the-power-bi-calculate-function\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"All you need to know about the Power BI CALCULATE function","description":"When using the Power BI CALCULATE function, as a professional should be aware about the fact that the function is..K.","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:\/\/datascientest.com\/en\/all-you-need-to-know-about-the-power-bi-calculate-function","og_locale":"en_GB","og_type":"article","og_title":"All you need to know about the Power BI CALCULATE function","og_description":"Visual Analytics is the union of data analysis and visualizations. This problem-solving approach aims to facilitate complex, high-level activities such as","og_url":"https:\/\/datascientest.com\/en\/all-you-need-to-know-about-the-power-bi-calculate-function","og_site_name":"DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-01-16T20:03:50+00:00","article_modified_time":"2024-01-16T20:09:07+00:00","og_image":[{"width":768,"height":421,"url":"https:\/\/datascientest.com\/en\/files\/2024\/01\/power-bi-calculate-funktion.webp","type":"image\/webp"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/all-you-need-to-know-about-the-power-bi-calculate-function#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/all-you-need-to-know-about-the-power-bi-calculate-function"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"All you need to know about the Power BI CALCULATE function","datePublished":"2024-01-16T20:03:50+00:00","dateModified":"2024-01-16T20:09:07+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/all-you-need-to-know-about-the-power-bi-calculate-function"},"wordCount":961,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/all-you-need-to-know-about-the-power-bi-calculate-function#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/all-you-need-to-know-about-the-power-bi-calculate-function","url":"https:\/\/datascientest.com\/en\/all-you-need-to-know-about-the-power-bi-calculate-function","name":"All you need to know about the Power BI CALCULATE function","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-01-16T20:03:50+00:00","dateModified":"2024-01-16T20:09:07+00:00","description":"When using the Power BI CALCULATE function, as a professional should be aware about the fact that the function is..K.","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/all-you-need-to-know-about-the-power-bi-calculate-function"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/176604"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=176604"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/176604\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/176606"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=176604"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=176604"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=176604"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}