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
Filters
Filtered value
Difference from filtered value
Percentage difference from filtered value
Sales from new customers
Time intelligence
Year-to-date total
Quarter-to-date total
Month-to-date total
Year-over-year change
Quarter-over-quarter change
Month-over-month change
Rolling average
Totals
Running total
Total for category (filters applied)
Total for category (filters not applied)
Mathematical operations
Addition
Subtraction
Multiplication
Division
Percentage difference
Correlation coefficient
Text
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
Result:
Comments