How to Compare Two Measures in Power BI
- George Apostolov
How to Compare Two Measures in Power BI: step-by-step guide
Open your report and go to the 'Modeling' tab.
Select 'New measure' to compare two measures.
When you have two measures, use this to enter the DAX formula.
Click on the check icon to commit and apply the changes.
Once you’ve created the comparison measure, you can save and share the data with your team.
Quick answer: To compare two measures in Power BI, open your report, navigate to the Modeling tab, and select New measure. Enter your DAX formula for the measures, click the check icon to commit the changes, and then save and share your data.
About this Power BI tutorial
Create a measure to compare data in Power BI by writing a DAX formula under the Modeling tab, committing the changes, and sharing your report. This guide shows how to compare Two Measures in Power BI in 5 steps, starting with "Open your report and go to the 'Modeling' tab" and finishing with "Once you’ve created the comparison measure, you can save and share the data with your team". The interactive demo above is a click-through copy of the real Power BI interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to compare Two Measures in Power BI?
5 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Power BI data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Power BI. Related guides: How to Connect a Smartsheet Document to Power BI, How to Connect Jira to Power Bi and How to Connect Power BI to a SharePoint Excel File. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
