Formula dax

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

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]
    )