LOADING

Type to search

Calculated Measures for Power BI

To Know more about the Different Corporate Training & Consulting Visit our website www.Instrovate.com Or Email : info@instrovate.com or WhatsApp / Call at +91 74289 52788

Data Analytics PowerBI

Calculated Measures for Power BI

Share

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:

Calculated Measures for Power BI 29

Select States:

Calculated Measures for Power BI 30

Right Click on Profit field:

Calculated Measures for Power BI 31

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

Calculated Measures for Power BI 32

Click on New measure:

Calculated Measures for Power BI 33

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)

Calculated Measures for Power BI 34

 

Calculated Measures for Power BI 35

Now we will select sales and Profit Margin for map:

Calculated Measures for Power BI 36

Go to format

Calculated Measures for Power BI 37

Change colours for Minimum and maximum:

Calculated Measures for Power BI 38

 

Calculated Measures for Power BI 39

 

Calculated Measures for Power BI 40

Drag State and city to in country hierarchy:

Calculated Measures for Power BI 41

 

Select any record from map:

Calculated Measures for Power BI 42

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

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

Calculated Measures for Power BI 43

Select any record:

Calculated Measures for Power BI 44we can see Percentage value for Profit Margin.

Drill map by using:

Calculated Measures for Power BI 45

 

Here we checked that Calculated Measures are changing with filter.

 

Calculated Measures for Power BI 46

Select drillup:

Calculated Measures for Power BI 47

Tags:

You Might also Like

Leave a Comment

Your email address will not be published. Required fields are marked *