topic Re: How to calculate the GM% based on two different columns in DAX Commands and Tips

How to calculate the GM% based on two different columns

TomPatrick22 — Tue, 19 Aug 2025 11:51:35 GMT

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

Re: How to calculate the GM% based on two different columns

FBergamaschi — Tue, 19 Aug 2025 12:06:56 GMT

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

Re: How to calculate the GM% based on two different columns

TomPatrick22 — Wed, 20 Aug 2025 00:17:58 GMT

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

Re: How to calculate the GM% based on two different columns

FBergamaschi — Wed, 20 Aug 2025 12:31:40 GMT

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

Re: How to calculate the GM% based on two different columns

v-achippa — Fri, 22 Aug 2025 13:23:29 GMT

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

Re: How to calculate the GM% based on two different columns

v-achippa — Mon, 25 Aug 2025 13:23:54 GMT

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

Re: How to calculate the GM% based on two different columns

v-achippa — Fri, 05 Sep 2025 12:28:10 GMT

Hi @TomPatrick22,

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?

If not, as FBergamaschi asked can you please provide the code in force now for GM%? So that we can look into the issue and provide you the best solution posiible.

Thanks and regards,

Anjan Kumar Chippa

Re: How to calculate the GM% based on two different columns

v-achippa — Fri, 12 Sep 2025 06:59:30 GMT

Hi TomPatrick22,

As we haven’t heard back from you, we wanted to kindly follow up to check if your issue is resolved?

We are closing this thread for now, if you have any other issues please raise a new thread in the community forum, we are ready to assist you on that.

Thanks and regards,

Anjan Kumar Chippa

Re: How to calculate the GM% based on two different columns

Ray_Minds — Fri, 23 Jan 2026 10:09:14 GMT

Hello TomPatrick22 Please find the below solution

1. Create a measure for Sales:

Total Sales = SUM('YourTable'[Sales])

2. Create a measure for Cost:

Total Cost =

SUM('YourTable'[Cost])

3. Create a measure for Gross Margin:

Gross Margin =

[Total Sales] - [Total Cost]

4. Finally, create Gross Margin %:

Gross Margin % =

DIVIDE([Gross Margin], [Total Sales], 0)