What is Measures in Power Bi?

Measures in Power Bi?

In Power Bi Desktop you can create your own measures to using Data Analysis Expressions (DAX) formula language to perform Aggregation level of Calculations such as COUNTS, AVERAGE, SUM, MAX, MIN & many more.

Why we need Measures?

1. When you have advance & complex level of calculations then you need to create measures. 
2. In power bi desktop there is 200 DAX functions available to using this you can perform complex calculations.
3. Through measures you can easily interact with your report, and it will display under your Dataset Field.

How to Create Measures in Power BI?

1. Right Click on Dataset, then click on "New Measure".
2. After that one formula bar appears just below report menu.

Here, we will create four separate Measures as mentioned below

Min_Unit_price = MIN ( Orders[Unit Price] )

Max_Unit_price = MAX ( Orders[Unit Price] )

Avg_Unit_Price = AVERAGE ( Orders[Unit Price] )

Count_Product_Category = DISTINCTCOUNT ( Orders[Product Category] )

Click on image for Zoom

Now take four Card or Multi Row card as per your choice from Visualization tab then select card and drag your measure into card as shown in above image.

So, Here we learn how we can create & display custom measures in Power Bi.

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always

welcome.