Table totals

[Anonymous]

Hello
I have a question
I don't know how to resolve this issue. 

I have measure CAC and i want to sum in the total but the measure calculate the row

the correct value is $222.222 not $7.055

HELP 

[Anonymous]

Thanks 

It worked 

: )

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

According to your description, you can try like this.

 CAC = SUMX(‘Table name’, CALCULATE(DIVIDE(Presupuesto[Presupuesto_diario_corregido],[Ventas_sin_FP_por_Source],0)))

You should add SUMX function to the code, then it will sum in the total, otherwise the total row will also execute the DIVIDE function.

I create a sample and it works fine.

Best Regards,
Community Support Team _ kalyj

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

[lbendlin]

Please show the measure code.

[Anonymous]

Hello 

sure, these are the measures

- CAC = DIVIDE(Presupuesto[Presupuesto_diario_corregido],[Ventas_sin_FP_por_Source],0)

- Presupuesto_diario_corregido = CALCULATE(DIVIDE(

SUM(Presupuesto[Total_Mensual]),

CALCULATE([Cuenta_días],REMOVEFILTERS(Source_Medium[Source / Medium])),0),USERELATIONSHIP('00_Calendario_Anual'[Fecha],Presupuesto[Fecha_Inicio]))

- Ventas_sin_FP_por_Source = CALCULATE(DISTINCTCOUNT('00_01_Historico_VinculaciónDigital_SalarioUPC'[Llave_Docum]),'00_01_Historico_VinculaciónDigital_SalarioUPC'[Agrupació_Fuerza_Comercial]="Sin FP")*[%_users]