Forum Discussion

ManuPulgar's avatar
ManuPulgar
Regular Visitor
1 year ago
Solved

Formula dax

Estimados necesito ayuda con alguna formula dax que me sume solo los valores una sola vez.

La tabla está de la siguiente manera:

 

Vendedor.      Clientes

José Pérez        86

José Pérez.       86

Pedro Marin.    74

Pedro Marin.    74

 

Necesito una formula dax que me sume solo una sola vez los valores de cada vendedor y no la totalidad de veces que aparece en la columna vendedor.

Para el caso me serviría que solo sumar 86 de José y 74 de Pedro.

 

Gracias

  • shafiz_p's avatar
    shafiz_p
    1 year ago

    Hi ManuPulgar  Try below code for summing up distinct value by Vendedor:

    DistinctSum = SUMX(
    SUMMARIZE(
        'Table',
        'Table'[Vendedor.],
        "DistinctClientes",
        DISTINCT('Table'[Clientes])
    ),
    [DistinctClientes]
)

     

     

     

    Hope this helps!!

    If this solved your problem, please accept it as a solution!!

     

     

    Best Regards,
    Shahariar Hafiz

  • Jihwan_Kim's avatar
    Jihwan_Kim
    1 year ago

    Hi,

    I am not sure how your semantic model looks like, but please check the below picture and the attached pbix file.

    I tried to create a sample pbix file like below.

     

     

     

    expected result measure: =
VAR _t =
    SUMMARIZE (
        Sales,
        Sales[Vendor],
        Sales[Sales]
    )
RETURN
    SUMX (
        _t,
        Sales[Sales]
    )

4 Replies

  • shafiz_p's avatar
    shafiz_p
    Super User
    1 year ago

    Hi ManuPulgar  Try below code for summing up distinct value by Vendedor:

    DistinctSum = SUMX(
    SUMMARIZE(
        'Table',
        'Table'[Vendedor.],
        "DistinctClientes",
        DISTINCT('Table'[Clientes])
    ),
    [DistinctClientes]
)

     

     

     

    Hope this helps!!

    If this solved your problem, please accept it as a solution!!

     

     

    Best Regards,
    Shahariar Hafiz

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    1 year ago

    Hi,

    I am not sure how your semantic model looks like, but please check the below picture and the attached pbix file.

    I tried to create a sample pbix file like below.

     

     

     

    expected result measure: =
VAR _t =
    SUMMARIZE (
        Sales,
        Sales[Vendor],
        Sales[Sales]
    )
RETURN
    SUMX (
        _t,
        Sales[Sales]
    )
    • ManuPulgar's avatar
      ManuPulgar
      Regular Visitor
      1 year ago

      Funciono!! muchas gracias por tomarse el tiempo en ayudarme.