How to calculate the GM% based on two different columns

[TomPatrick22]

Hi,

Please help create a condition to calculate the difference of two different version for my GM%.

See below illustration, my "vs Flash" and "vs AOP" is not getting the difference of my Actual, Flash and AOP.

Thanks,

Tom

[v-achippa]

Hi @TomPatrick22,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @jaineshp and @FBergamaschi for the prompt response. 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user for the issue worked? Is your issue resolved? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @TomPatrick22,

We wanted to kindly follow up to check if the solution provided by the user for the issue worked? Is your issue resolved? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[FBergamaschi]

Please provide more information:

1 How is that visual arranged?

2 Are you using a calculation group?

3 Actual, Flash, AOP, vs Flash, vs AOP, are they calculation items? Or what?

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[FBergamaschi]

OK thanks for the answer

To fix, then you need to redefine the measure GM%

What is the code in force now for GM%?

If I see that, I can fix it

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[TomPatrick22]

Hi Francisco,

The GM% is a measures i created to calculate the %. The Actual, Flash, AOP, vs Flash and vs AOP are items i have in my column called version. 

Thanks for helping.

Tom

[jaineshp]

Hey @TomPatrick22,

Looking at your table, I can see the issue with your GM% variance calculations. Here's how to fix it:

Problem Analysis

Your "vs Flash" and "vs AOP" columns aren't showing percentage point differences correctly. You need calculated columns that compare your Actual GM% against Flash and AOP versions.

Solution Steps

1. Create "vs Flash" Calculated Column:

    vs Flash = [Actual GM%] - [Flash GM%]

2. Create "vs AOP" Calculated Column:

vs AOP = [Actual GM%] - [AOP GM%]

3. Format as Percentage:

• Select both new columns
• Set format to Percentage with 1-2 decimal places
• This will show proper variance (e.g., +2.5% or -1.8%)

Expected Results

• vs Flash: 312.0% - 1552.0% = -1240.0%
• vs AOP: 312.0% - 2258.1% = -1946.1%

Alternative Approach

If you want percentage change instead of percentage points:

vs Flash % Change = ([Actual GM%] - [Flash GM%]) / [Flash GM%]

Quick Check: Your Actual GM% of 312% seems unusually high - verify if this should be 31.2% instead, as this would make more sense for gross margin calculations.

Fixed? ✓ Mark it • Share it • Help others!

Best Regards,
Jainesh Poojara | Power BI Developer