Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
EMSSS22
Helper I
Helper I

Writing a measure to subtract two columns same table with filters

Hi 

 

I have 2 columns that i would like to subtract from one another after applied filters.

 

Eg.

 

Column B (with version type x and month number x) - Column A (with version type x and month number x)

 

 

What I currently have and is giving me wrong answer:

 

ForecastCMVariance = CALCULATE(SUM(FilteredCommercial[Forecast]) - CALCULATE(SUM(FilteredCommercial[Capital Rental])))

 

How do I go about writing this dax?

 

DAX filter 

4 REPLIES 4
tamerj1
Super User
Super User

Hi @EMSSS22 

Are version type and month number from the same table or different tables? What are the relationship between the tables? When you refer to "x" is it the same value used to filter both columns?

Hi 

 

Yes its the same table.

 

and

 

Yes the same filter needs to be applied to both columns.

 

Thanks 🙂

@EMSSS22 

Apologies for the late reply. Please try

ForecastCMVariance =
SUMX (
FILTER ( Commercial, Commercial[Version] = "x" && Commercial[month number] = y ),
Commercial[Forecast] - Commercial[Capital Rental]
)

johnt75
Super User
Super User

Try something like

ForecastCMVariance =
CALCULATE (
    SUMX (
        FilteredCommercial,
        FilteredCommercial[Forecast] - FilteredCommercial[Capital Rental]
    ),
    FilteredCommercial[Version] = "x",
    FilteredCommercial[month number] = y
)

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.