Introduction :
Quick measure is a powerful feature used to perform calculations easily and quickly. Quick measure contains a set of DAX queries that runs in the background and the result will show in your report. So, you don’t need to write any DAX query in Power Bi. When you create a quick measure, it will be added in to your table and the calculation that’s running behind will be shown in your report. Kit is a very useful feature to get results from complex functions and queries like calculating ‘Correlation coefficient’ etc.
Quick measure contains five main types of calculations which are mentioned below,
- 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
- Concatenated list of values
How to add quick measure
To add quick measure, there are two ways:
Select table and go to ‘Home’ tab and click on ‘Quick measure’.
or you can right click on selected table and then click on ‘New quick measure’.
In both ways when you click on quick measure a new window will be opened which lets you perform calculations.
For example, I calculate ‘Average per category’. So, click on it. Provide ‘base value’ and ‘Category’ here and click on ‘Ok’ to apply formula.
After clicking on ‘Ok’ a new measure will be added in your table and the formula will be shown at the screen. In the below image I have highlighted the new measure.
To check the value of the newly added quick measure you can select ‘Card’ visual. The result will be shown in your selected visual. See the below image.
This is how you can add quick measure in your table and show it in your report. Similarly, you can use other in-built calculations by using the quick measure feature.
For any Help or Queries Contact us on info@crmonce.com or +918096556344
