MY GP % return wrong value

[admin11]

Hi All

I have a expression :-

SALES GP % = DIVIDE((SALES_T[SALES_T] - SALES_T[COST_]),SALES_T[SALES_T])

it return wrong value .

I manage to get the COST and SALES amount right . But GP % wrong. Forumla s correct.

My PBI file :-

https://www.dropbox.com/s/9u26zoe3xjzzl36/PBTI_V026%20ASK.pbix?dl=0

Hope some one can advise me where go wrong ?

Paul

[Anonymous · Accepted solution]

Hi @admin11 ,

You are doing SALES_T GP % as a calculated column, hence it is proving the wrong value.

Create it as measure with the same formula and it will show you the correct result.

SALES_T GP % = DIVIDE((SALES_T[SALES_T] - SALES_T[COST_T]),SALES_T[SALES_T])

[admin11]

@Anonymous 

So total there 3 type , measure , column and calculate. Right ? 

[Anonymous]

@admin11 Two only- Calculated column and Calculated measure

[admin11]

@Anonymous 

Thank you for your sharing 

Paul