topic Re: Dividir entre dos objetos visuales in DAX Commands and Tips

Dividir entre dos objetos visuales

Dajakda — Mon, 14 Oct 2024 23:40:24 GMT

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

Re: Dividir entre dos objetos visuales

aduguid — Tue, 15 Oct 2024 02:20:22 GMT

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)

Re: Dividir entre dos objetos visuales

Anonymous — Tue, 15 Oct 2024 08:32:53 GMT

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.