top of page

Use quick measures for common calculations in Power BI

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

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:

  1. Open your dataset in Power BI.

  2. Click on "New Measure" to create a new calculated column.

  3. Enter the following settings

Result:










9 views0 comments

Recent Posts

See All

Comments

Rated 0 out of 5 stars.
No ratings yet

Add a rating
bottom of page