Total of measure is wrong.

[yforti]

Hi guys!

I have a problem when i use my calculated measures in a table. I created the following measures:

Recebido =  CALCULATE([VL Rec Total];FILTER(OPMEXCONTA;OPMEXCONTA[OPME_x_NF_Itaim_01_07_19_a_3_20.Custo]<>BLANK())

Custo = CALCULATE(SUMX(OPMEXCONTA;OPMEXCONTA[OPME_x_NF_Itaim_01_07_19_a_3_20.Custo]))

Lucro custo total = CALCULATE([teste 1]-[Custo])

margem custo total = DIVIDE([Lucro custo total];[teste 1];0)

Here's the problem:

When i use the measure "margem custo total" (trying to calculate the profit margin) the total is calculated incorrecly for the first level categories (for exemple: Golden Cross-> Blue Circle), but for the second level categories the calculetion is correct (yellow).

Can anyone helpe me?

[parry2k]

@yforti what is [VL Rec Total] measure 

[yforti]

@parry2k 

1. VL Rec Total = CALCULATE([VL Rec OPME]+[VL Rec Pacote]+[VL Rec Simultâneo Total])
   1. VL Rec OPME = CALCULATE(SUMX(OPMEXCONTA;OPMEXCONTA[VLRECEBIDOOPME]))
   2. VL Rec Pacote = CALCULATE([VLFINALCALCULADO] - [GlosaPacote];FILTER(OPMEXCONTA;OPMEXCONTA[VLRECEBIDOPACOTE]<>BLANK()))
      1. VLFINALCALCULADO = CALCULATE(SUMX(OPMEXCONTA;OPMEXCONTA[VLFINAL]))
      2. Glosa Pacote = CALCULATE(SUMX(OPMEXCONTA;OPMEXCONTA[GLOSA PACOTE TRATADA]))
   3. VL Rec Simultâneio Total = CALCULATE([Vl rec simultâneo]+[Vl rec simultâeneo2])
      1. Vl rec simultâneo = CALCULATE([VLFINALCALCULADO];OPMEXCONTA[Status conta] = "Recebido Simultâneo")
      2. Vl rec simultâneo 2 = CALCULATE(SUMX(OPMEXCONTA;[Qtd Rec Simultâneo]*[VLunitposmax]);FILTER(OPMEXCONTA;OPMEXCONTA[Status Item]="Recebido Simultâneo");FILTER(OPMEXCONTA;[Glosa Externa] = BLANK()))

[parry2k]

@yforti there is a lot more going on, are you open to share pbix file with sample data, remove sensitive information before sharing. You can share using one drive/google drive.

[yforti]

@parry2k 

See if it helps: https://drive.google.com/drive/folders/1EZTaPMOFI8j3MD8FvXwxA2sMjzOXy-RH?usp=sharing