Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
Solved

Division DAX

Good afternoon

I have a table where I have the invoice per salesperson, and I have another table where I have the goal per floor where each salesperson works, I would like to be able to calculate the scope of the seller's goal globally regardless of whether they have sold on another floor other than the one initially assigned (for this I would have to divide what was sold by only the goal of the assigned floor) or add the percentages obtained for each floor that seems fair to me.

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Syndicate_Admin ,

    Regarding your question, if I understand you correctly, you are trying to add these values and then divide them, correct?

    The Table data is shown below:

    Please follow these steps:
    1. Use the following DAX expression to create a column in 'Table2'

     

    Column = LOOKUPVALUE('Table'[Meta Monto Asesor Mes],'Table'[Piso],'Table2'[Piso])

     

    2.Use the following DAX expression to create a table

     

    Table3 =
ADDCOLUMNS (
    SUMMARIZE (
        'Table2',
        Table2[NOMBRE Y APELLIDO ODOO],
        "Total Facturado", SUM ( Table2[Facturado] ),
        "Total Meta Monto Asesor Mes", SUM ( Table2[Column] )
    ),
    "Scope", DIVIDE ( [Total Facturado], [Total Meta Monto Asesor Mes] )
)

     

    3.Final output

     

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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Syndicate_Admin ,

    Regarding your question, please provide brief data and show the expected results in the form of pictures.

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      2 years ago

      Good morning

      Images are attached

      Here are the goals where the Goal Amount Advisor Month field should be the denominator of the EA scope calculation

      The drawback I have is in the scope by amount since, as can be seen in the table, there are advisors who repeat because they made sales on several floors, however I need to add those scopes and present a grouping

      Best regards

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Syndicate_Admin ,

        Regarding your question, if I understand you correctly, you are trying to add these values and then divide them, correct?

        The Table data is shown below:

        Please follow these steps:
        1. Use the following DAX expression to create a column in 'Table2'

         

        Column = LOOKUPVALUE('Table'[Meta Monto Asesor Mes],'Table'[Piso],'Table2'[Piso])

         

        2.Use the following DAX expression to create a table

         

        Table3 =
ADDCOLUMNS (
    SUMMARIZE (
        'Table2',
        Table2[NOMBRE Y APELLIDO ODOO],
        "Total Facturado", SUM ( Table2[Facturado] ),
        "Total Meta Monto Asesor Mes", SUM ( Table2[Column] )
    ),
    "Scope", DIVIDE ( [Total Facturado], [Total Meta Monto Asesor Mes] )
)

         

        3.Final output

         

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