Dividir entre dos objetos visuales

[Dajakda]

Hola, tengo estos dos objetos visuales y me gustaría crear un tercer objeto que muestre el resultado de la división entre altas/preventas mes en valor porcentual. Agradezco su ayuda por favor

[aduguid · Accepted solution]

If you don't already have these as measures, I'd create them.

Preventas Mes = SUM(Table[Preventas Mes])

Altas = SUM(Table[Altas])

Then you can create the percentage

Percentage = DIVIDE([Altas], [Preventas Mes], 0)

[Anonymous · Accepted solution]

Hi @Dajakda ,

Maybe you can try formula like below to create measure:

sum_s =
CALCULATE (
    SUM ( TableS[PreSalesAmount] ),
    FILTER ( 'TableS', TableS[Month] = [Sel] )
)

sum_p =
CALCULATE (
    SUM ( TableP[PreSalesAmount] ),
    FILTER ( 'TableP', TableP[Month] = [Sel] )
)

result = DIVIDE([sum_s],[sum_p])

Best Regards,
Adamk Kong

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

[aduguid · Accepted solution]

If you don't already have these as measures, I'd create them.

Preventas Mes = SUM(Table[Preventas Mes])

Altas = SUM(Table[Altas])

Then you can create the percentage

Percentage = DIVIDE([Altas], [Preventas Mes], 0)