Creating Measures in Your Fabric Semantic Model

Published

October 25, 2024

Measures in Power BI are calculations used in reports and dashboards to analyze data. They are created using DAX (Data Analysis Expressions) and can perform various calculations, such as aggregations, comparisons, and conditional logic. Measures are essential for deriving insights from your data and making informed business decisions.

Step 1: Navigate to Your Workspace

Navigate to workspace — Navigate to Workspace

Step 2: Select Your Semantic Model

In the workspace, click on your semantic model.

Click on Semantic model — Click on Semantic Model

Step 3: Open the Data Model

After selecting your semantic model, open the data model.

Step 4: Create a New Measure

In the data model, click on New Measure to create a new calculation.

Step 5: Write Your Measure

Write your DAX calculation in the formula bar. You can use DAX functions and operators to create complex calculations based on your data. Click Enter to save your measure.

Write DAX calculation — Write DAX Calculation

If needed, you can format your measure by selecting the appropriate data type and formatting options.

Have a great day!

Hi,

I’m Snorre

I’m a Data Engineer and Business Analyst with a background in Economics. I love diving into data and turning it into something meaningful using tools like Microsoft Fabric, Power BI, and Azure Data Factory. Over the years, I’ve worked on everything from data migrations to building reports and dashboards that help organizations really make the most of their data.

I’ve had the chance to work in a variety of environments, and I’m all about creating solid, scalable solutions that drive digital transformation. I also enjoy sharing what I know through training sessions and webinars, always looking to help others get more comfortable and skilled with data.

When I’m not working on data projects or teaching, you’ll probably find me outdoors—whether I’m working in the forest, traveling, or just hanging out with friends and family. I also like getting involved in testing out new Microsoft features, giving feedback to make sure they’re as useful as possible before they’re released.

Snorre Glemmestad