Divide problems

[Analitika]

Have some problems with measures

1. Wrong divide so 22670/21 = 1 079.52, but measure % = divide([5],[6000])  return 119747,48 

2. measure % = divide([5],[6000])  return 119747,48 % but should return 1197,47 % like measure Marge, but something went wrong, all measure is same

measure 5 = CALCULATE(
sumx(Table1, [SUM_CRE]-[SUM_DEB]),
FILTER(CodeTable,left([sas_kod],1)="5"))

measure 6 = CALCULATE(
sumx(Table1, [SUM_CRE]-[SUM_DEB]),
FILTER(CodeTable,left([sas_kod],1)="6"))

measure 6000 = CALCULATE(
sumx(Table1, [SUM_CRE]-[SUM_DEB]),
FILTER(CodeTable,left([sas_kod],4)="6000"))

measure [BP] = [5]-[6]

measure marge = DIVIDE([BP],[5])

[V-lianl-msft]

Hi @Analitika ,

Unfortunatly,I don't know your data model. Using your measure works well in my test file. If the problem still exists, can you tell me your data model so that I can do more tests.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.