You can use quick measures to quickly and easily perform common, powerful calculations. A quick measure runs a set of Data Analysis Expressions (DAX) commands behind the scenes, then presents the results for you to use in your report. You don't have to write the DAX, it's done for you based on input you provide in a dialog box. There are many available categories of calculations and ways to modify each calculation to fit your needs. Best of all, you can see the DAX that's executed by the quick measure and jump-start or expand your own DAX knowledge.
Quick measure calculation types in Power BI
Aggregate per category
Average per category
Variance per category
Max per category
Min per category
Weighted average per category
Difference from filtered value
Percentage difference from filtered value
Sales from new customers
Total for category (filters applied)
Total for category (filters not applied)
Concatenated list of values
Star rating example in Power BI
Sample Data: Suppose you have a product dataset with their respective review scores. For simplicity, I'll create a sample dataset with the following data:
The "Review Score" column represents the average rating for each product, ranging from 1 to 5.
Quick Measure: Text Star Rating Now, we'll create a Quick Measure that converts the numeric review scores into text-based star ratings. The mapping we'll use is as follows:
Here are the steps to create the Quick Measure in Power BI:
Open your dataset in Power BI.
Click on "New Measure" to create a new calculated column.
Enter the following settings