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?
- When you have advance & complex level of calculations then you need to create a measures.
- In Power BI desktop more then 200 + DAX functions are available to using this you can perform complex calculations.
- Through measures you can easily interact with your report, and it display under your Dataset Field.
- Not stored in memory(RAM), Consumes CPU for calculation.
Let’s get started-
Download the sample Dataset from below link-
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 one 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 visualization pane to Power BI report page then drag your measure into card visuals as shown in below image.
Measures in Power BI
In same way you can create a measure with other DAX functions, also you can use same measure multiple times as per your need.
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: