Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Duplicate Measure in Power BI

Cody Schneider••8 min read

Need to create a measure in Power BI that’s almost identical to one you already built? Don't start from scratch. Duplicating a measure is a fundamental time-saving trick that lets you quickly build variations of existing calculations without reinventing the wheel. This article will guide you through the easiest and most practical ways to duplicate measures so you can prototype reports, build complex comparisons, and maintain your DAX code more efficiently.

GraphedGraphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Watch Graphed demo video

Why Duplicating Measures is a Game-Changer

Before jumping into the "how," let's quickly cover the "why." Understanding the benefits will help you recognize when duplicating a measure is the right move for your report. It’s more than just copying and pasting, it’s about making your workflow smarter and more scalable.

  • Speed and Efficiency: This is the most obvious benefit. Why re-type a complex DAX formula when you can copy it? If you have a measure that calculates Total Sales, you're only a few clicks away from having Total Sales Previous Year or Total Sales YTD in a fraction of the time it would take to write them from the ground up.
  • Consistency and Accuracy: Manually recreating similar DAX formulas invites typos and logic errors. When you duplicate a measure, you’re guaranteeing that the core logic remains identical. This is extremely important for related metrics. For instance, if all your sales measures (Total Sales, Sales MTD, Sales Target Variance) start from the same base calculation, you can be confident they operate from a single source of truth.
  • Painless Experimentation: Not sure if a new CALCULATE filter will give you the right result? Duplicate a measure and test your idea without risking your original, working version. This lets you freely explore your data and build "what-if" scenarios, like filtering total sales for a specific marketing campaign or comparing performance across different date ranges, all without fear of breaking your dashboard.

In short, duplicating measures lets you work faster, reduce errors, and build out your data model with more confidence. Let's get into the methods.

Method 1: The Classic Copy-and-Paste Technique

This is the most common and direct method for duplicating a measure within Power BI Desktop. It’s simple, intuitive, and something you'll use daily. You just copy the DAX formula from one measure and paste it into a new one.

Let's walk through it with a practical example. Say you have a basic measure for calculating an average order value:

Average Order Value = AVERAGEX('Sales Orders', 'Sales Orders'[Order Total])

Now, you want to create a new measure showing the average order value but only for online sales. Here’s how you’d use the copy-and-paste method:

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Step-by-Step Instructions:

  1. Locate Your Measure: Find your existing measure, Average Order Value, in the Fields pane on the right side of the Power BI window.
  2. Reveal the Formula: Click on the measure. The DAX formula will appear in the formula bar just below the main ribbon.
  3. Copy the DAX Code: Click inside the formula bar, highlight the entire DAX expression (a quick Ctrl + A or Cmd + A works well), and copy it to your clipboard (Ctrl + C or Cmd + C).
  4. Create a New Measure: Now, you need a new, blank measure to paste the formula into. The easiest way is to navigate to the Modeling tab in the ribbon and click New Measure. You can also right-click on the table where you want the measure to live and select New Measure.
  5. Paste and Rename: Power BI will create a placeholder formula: Measure =. Delete the word "Measure" and give it a descriptive name, like AOV Online Sales. Then, paste your copied DAX code after the equals sign (=).

Your formula bar should now look like this:

AOV Online Sales = AVERAGEX('Sales Orders', 'Sales Orders'[Order Total])
  1. Modify the Formula: Finally, wrap your pasted DAX in a CALCULATE function to add the new filtering logic. In our case, we want to filter for online sales. The final, modified measure might look like this:
AOV Online Sales =
CALCULATE (
    AVERAGEX('Sales Orders', 'Sales Orders'[Order Total]),
    'Sales Orders'[Channel] = "Online"
)

Press Enter to save your new measure. That's it! You've successfully duplicated and modified a measure in under a minute.

Method 2: Building Upon Base Measures (The Analyst's Best Practice)

While copy-and-paste is fast for one-off tasks, a more organized and scalable approach is to create simple "base" measures and then build more complex measures that refer to them. Instead of duplicating the entire DAX expression each time, you only refer to the original measure by its name. This strategy is often called measure branching or building a measure tree.

The core idea is to define your fundamental calculations once. For example, create very simple measures like:

  • Total Sales = SUM('Sales'[Sale Amount])
  • Total Cost = SUM('Sales'[Total Cost])
  • Total Units Sold = SUM('Sales'[Units])

These are your building blocks. Now, when you need a more advanced calculation, you don't copy the SUM('Sales'[Sale Amount]) part. You just refer to [Total Sales].

GraphedGraphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Watch Graphed demo video

Example of Measure Branching:

With [Total Sales] as our base, look how clean and easy it is to create variations:

  • To get Year-to-Date sales, you write:
Total Sales YTD = TOTALYTD([Total Sales], 'DimDate'[Date])
  • To get sales from the Previous Year, you write:
Total Sales PY = CALCULATE([Total Sales], SAMEPERIODLASTYEAR('DimDate'[Date]))
  • To get the Year-over-Year change, you can now combine your new measures:
Sales YoY % = DIVIDE(([Total Sales] - [Total Sales PY]), [Total Sales PY])

Why This Method is Superior for Large Reports:

  • Maintainability: Imagine your company changes how it defines "Sale Amount." Maybe it now needs to exclude tax. If you had duplicated the SUM(...) formula ten times, you’d have to find and update it in ten different places. With base measures, you update the [Total Sales] measure once, and all the dependent measures (YTD, PY, YoY %, etc.) automatically reflect the change.
  • Readability: The formulas are shorter and much easier to understand. Anyone looking at your DAX can immediately see that Total Sales YTD is based on the logic of Total Sales, making the model easier to audit and troubleshoot.

Method 3: The Power User Shortcut with Tabular Editor

For those managing large models with dozens or hundreds of measures, manually copying and pasting can become tedious. This is where external tools become lifesavers. Tabular Editor is a free, powerful tool that allows you to edit your Power BI data model more directly - including duplicating measures with just two clicks.

If you're new to it, you can install it and launch it from the External Tools tab in Power BI Desktop.

How to Duplicate in Tabular Editor:

  1. Launch the Tool: With your Power BI report open, go to the External Tools ribbon and click Tabular Editor.
  2. Find Your Measure: Inside Tabular Editor, navigate through the model tree on the left. Expand Tables, find the table containing your measure, and expand its Measures folder.
  3. Duplicate It: Right-click the measure you want to copy and select Duplicate from the context menu.
  4. Rename and Edit: A copy will instantly appear (e.g., _Total Sales_ 2). Click it once to rename it in the tree, or use the Properties pane on the right. Modify the DAX expression directly in the expression editor below.
  5. Save Changes: Click the save icon (or press Ctrl + S) in Tabular Editor. The new measure will immediately appear in your Power BI model in the Fields pane, ready to use.

The true power here is working in bulk. In Tabular Editor, you can select multiple measures (with Ctrl + click), right-click, and duplicate them all at once - a massive time-saver for repetitive tasks.

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Best Practices and Common Mistakes to Avoid

No matter which method you choose, a few simple habits will keep your Power BI reports organized and error-free.

  • Develop a Rigid Naming Convention: Chaos in the Fields pane is a report developer's nightmare. Be consistent with how you name measures. Use prefixes like _ for hidden base measures that users don’t need to see, or suffixes like YTD, YoY, and PY. This makes measures easy to find and understand.
  • Always Use a Proper Date Table: Many duplicated measures are time intelligence functions (SAMEPERIODLASTYEAR, TOTALYTD, etc.). None of these work correctly without a properly formatted, contiguous date table marked as a date table in your model.
  • Add Comments to Complex DAX: When you modify a duplicated measure for a very specific purpose, add a comment (// for a single line) explaining the change. It helps you (and your teammates) remember the formula's purpose months later.

Final Thoughts

Mastering how to duplicate measures is a simple yet powerful step toward becoming more proficient in Power BI. Whether you use the straightforward copy-and-paste method for quick tasks, adopt the best practice of building on base measures for scalability, or leverage Tabular Editor for bulk editing, each technique helps you produce more accurate reports in less time.

While optimizing your workflow inside Power BI is a massive help, sometimes the real efficiency gain comes from rethinking the reporting process itself. We built Graphed because we know that connecting data, building dashboards, and answering business questions shouldn't require you to be a DAX wizard. Instead of copying and branching measures one by one, you can connect your data sources - like Google Analytics, Salesforce, or Shopify - and simply ask a question. Need to "compare Facebook Ads spend vs. revenue by campaign for Q3 last year vs. this year"? Just ask, and we build the live dashboard instantly. It lets you get straight to the insights, not the setup.

Related Articles