Calculated Measures for Power BI

If you are looking for a Microsoft Power BI Corporate Training in Gurgaon , please feel free to reach out at akriti.lal@instrovate.com or whatsapp at +91-9953805788 

In my previous blog I have explained about adding Calculated column in Power BI.

Today I will explain about adding Measures for Power BI. First of all we will go through differences between Calculated column and Calculated Measure.

 

Calculated column – Calculated Column are calculated before aggregation at row level.

They are used for row by row calculation, like excel.

Calculated columns are not recalculated when there is any change in filter on dashboard.

Calculated columns stored inside our data set. Calculated column takes up space in RAM memory. So it should not be used when we have very large data e.g. in million.

Calculated columns act like a normal column and can be used in relationship and calculations.

Calculated columns are used when need to slice or filter on value

Calculated Measures: Measures are calculated after aggression. They are used for calculations across rows

Measure are calculated every time when we recreate/ recalculate visualization or use filters, it is dynamic thing and calculate on fly when required. It Returns different answer depending on the filters applied

Measures are Not stored in RAM, It consumes CPU.

Measures can be used on other measures.

Measures can be moved between tables.

Measures cannot be used for relationships.

Measures are used to calculate percentages, calculate rations, and need complex aggregations

Load Sample file in Power BI:

Select States:

Right Click on Profit field:

Here we can see New Measure in menu, click on it:

Click on New measure:

It will add new column as measure we can give some different name to this field and add formula to calculate Profit Margin (Sum of profit field divided by the sum of Sales field)

 

Now we will select sales and Profit Margin for map:

Go to format

Change colours for Minimum and maximum:

 

 

Drag State and city to in country hierarchy:

 

Select any record from map:

Value for Profit margin is in whole number, let we change it in %

Select Modelling menu and select % sign for Profit Margin field:

Select any record:

we can see Percentage value for Profit Margin.

Drill map by using:

 

Here we checked that Calculated Measures are changing with filter.

 

Select drillup:

 

Comments

There are no entries yet.
Please enter the code
* Required fields

Subscribe to our mailing list

* indicates required

Looking for Corporate Training ? Reach out to us at Akriti.Lal@instrovate.com

Reach out to us if you are looking for Corporate Training to Build The Next Generation Analytical Workforce with an in-depth understanding of  Exploratory Data Analysis , Data Visualisation, Data Analytics , AI First , Machine Learning & Deep Learning Training & Consulting helping them to take Data Informed Decision at each stage of the business. 

We understand that At the present times , the Entire Industry is in a Tranformation stage with the Softwares  being rebuilt with Artificial Intelligence Capabilities .

We need SMART WORKFORCE for the SMART SOFTWARES to reap the maximum return . 

 

Whatsapp at +91-9953805788 or email at - akriti.lal@instrovate.com if you would like to know more . 

 

  • Corporate Tableau Training in Gurgaon
  • Corporate Data Analytics Training in Gurgaon
  • Corporate Microsoft Power BI Training in Gurgaon
  • Corporate Microstrategy Training in Gurgaon
  • Corporate Google Data Studio Training in Gurgaon
  • Corporate Python Training in Gurgaon
  • Corporate Advance Analytics in R Programming Training in Gurgaon
  • Corporate Machine Learning Training in Gurgaon
  • Corporate Deep Learning Training in Gurgaon
  • Corporate Data Visualization Training in Gurgaon

 

Address

Instrovate Technologies

Noida, Gurgaon

 

akriti.lal@instrovate.com 

Hit Your Refresh Button To Rise Higher
Print Print | Sitemap
All rights reserved @ Instrovate Technologies
GSTIN : 09AAECI6862K1Z1

Terms Of Services    Privacy Policy    Disclaimer     Refund Policy    


Call

E-mail