Measure - Count of Orders

A measure is a calculation that works across an entire table, and is calculated when the visualisation is rendered.

  1. Go to report view, right-click on the OrderDetails table and select New measure from the Fields Pane (top-right of the report page). Select New Measure

  2. Enter the following DAX then hit Enter:

Count of Orders = COUNTROWS('OrderDetails')

DAX A new field is created called Count of Orders and it should have a calculator icon next to it.
Calculator

We are now going to format Count of Orders using a comma.

  1. Select the Count of Orders from OrderDetails. It should be highlighted in a grey shade.
    Select Order Details

  2. Under Measure Tools tab > Select the comma as highlighted in red square Select Comma