Home » Power BI » Power Bi – Quick Measures

Power Bi – Quick Measures

Quick Measures in Power Bi

Quick measures are Pre-built or you can say readymade measures. You don’t have to write DAX formula for this, it’s done for you based on input you provide in a quick measure dialog box.

Also it help to you write or understand the DAX formula.

So, Let’s start with an example,  you can download the sample Dataset from below link

Follow the below steps:-

  • Open Power Bi file
  • Load Sample data set
  • Right click on ‘order’ Data Set under Fields Pane
  • Then click on ‘New quick measure’
Quick Measure

Quick Measure

  • After that one quick measure dialog box appears and  then select calculations
Quick Measure Calculation

Quick Measure

Quick measure provides five type categories of calculations and they are

  • Aggregate per category
  • Filters
  • Time intelligence
  • Totals
  • Mathematical operations
  • Text

So, let’s start with Mathematical operations, Sample data set screen shot as below

Sample Data for Power Bi

Sample Data for Power Bi

Now add ‘unit Price’ & ‘Profit’ fields to using quick measure Addition Calculation.

Mathematical Operations

Mathematical Operations

Drag ‘Profit’ & ‘Unit Price’ fields under Base value box and Value to add then click on OK button for further proceed.

Addition Calculation quick measure

Addition Calculation quick measure

Created measure by Quick Measures as below

Unit Price plus Profit =

SUM(‘Orders'[Unit Price]) + SUM(‘Orders'[Profit])

Now drag new measure into table visual and it will returns sum of Profit & Unit Price as  in new column.

Same you can play with another calculations, process will be same.

Similar Post

Measures in Power Bi

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:

Power Bi Performance Analyzer

How to create Custom Theme in Power Bi

Custom Tooltips in Power Bi

Enable Syncs Slicers in Power Bi

Power Bi Interviews Q & A

Power Bi Group

Hierarchies in Power BI

 

Leave a Reply