SUM INCORRECT

Hi afrutos ，

According to your description, the measure NºBENEFICIARIOS can get correct result in each row but incorrect in total, but SUMX BENEFICIARIOS is correct in total but not in each row. Here's my solution.

Suppose the column in Solicitudes/ayudas related to 'PROYECTOS'[NombreWeb] named [Column].

Measure =
IF (
    HASONEVALUE ( [NombreWeb] ),
    CALCULATE (
        DISTINCTCOUNT ( 'Solicitudes/ayudas'[idAutor] ),
        KEEPFILTERS ( 'PROYECTOS'[NombreWeb] <> "ACCIDENT INSURANCE AND TRAVEL ASSISTANCE" )
    ),
    SUMX (
        SUMMARIZE (
            'Solicitudes/ayudas',
            'Solicitudes/ayudas'[Column],
            "Value",
                CALCULATE (
                    DISTINCTCOUNT ( 'Solicitudes/ayudas'[idAutor] ),
                    KEEPFILTERS ( 'PROYECTOS'[NombreWeb] <> "ACCIDENT INSURANCE AND TRAVEL ASSISTANCE" )
                )
        ),
        [Value]
    )
)

Best Regards,
Community Support Team _ kalyj

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