In Power BI Desktop, you can create your own measures using the Data Analysis Expressions (DAX) formula language to perform various aggregation-level calculations, including COUNT, AVERAGE, SUM, MAX, MIN, and many more.
Why we need Measures?
- When you have advanced and complex calculations, you need to create measures.
- In Power BI Desktop, there are over 200 DAX functions available, which you can use for complex calculations.
- Using measures, you can easily interact with your report, and they are displayed under your dataset fields.
- Measures are not stored in memory (RAM) but consume CPU for calculations.
Let’s get started!
Download the sample dataset from the link below:
How to Create a Measures in Power BI?
Follow these steps-
Step-1: Right-click on Data set, then click on “New Measure“.
Step-2: After that, a formula bar screen appears. Now, create four separate measures as mentioned below:
AVG Sales = AVERAGE(Orders[Sales])
MAX Sales = MAX (Orders[Sales])
MIN Sales = MIN (Orders[Sales])
SUM Sales = SUM (Orders[Sales])
Step-3:Now, add four Card visuals from the Visualization pane to the Power BI report page, then drag your measure into the Card visuals, as shown in the image below.
Measures in Power BI
Similarly, you can create measures using other DAX functions, and you can utilize the same measure multiple times as needed.
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.
Recommended Post: