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

[v-achippa · Accepted solution]

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

[v-achippa]

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

[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