Forum Discussion
Dividir entre dos objetos visuales
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
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)- Anonymous1 year ago
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- aduguidMemorable Member
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) - AnonymousNot applicable
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.