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’
- After that one quick measure dialog box appears and then select calculations
Quick measure provides five type categories of calculations and they are
- Aggregate per category
- Time intelligence
- Mathematical operations
So, let’s start with Mathematical operations, Sample data set screen shot as below
Now add ‘unit Price’ & ‘Profit’ fields to using quick measure Addition Calculation.
Drag ‘Profit’ & ‘Unit Price’ fields under Base value box and Value to add then click on OK button for further proceed.
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.
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.