Forum Discussion

Dajakda's avatar
Dajakda
Regular Visitor
1 year ago
Solved

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)

     

  • Anonymous's avatar
    Anonymous
    1 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 Kong

     

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

2 Replies

  • aduguid's avatar
    aduguid
    Memorable 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)

     

  • Anonymous's avatar
    Anonymous
    Not 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 Kong

     

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