Realizar una suma de valores descartando duplicados

[CarlosP]

Hola

Estoy realizando una comparacion de costo contra venta, pero al momento de realizar la consulta me considera valores duplicados. Estos valores deben quedarse porque me sirven para realizar otros reportes.

El valor correcto es el de la tarjeta de facturación

[v-denglli-msft · Accepted solution]

Hi @ CarlosP,

Based on the information you provided, I did some testing.

The data table is shown below.

The card visual uses the same Sales column as the table visual /Sum of Sales/ column.

Even if Sum of Sales contains duplicate values, the total value of the column is the same as the card visual display value. There is no reproduction of your problem.

Therefore, I would like to confirm something.

Does your card visual get the effect of any filters such as slicers, filters for that page or filters from other pages.

If you remove the /sinfact2.siniestro/ column from your table visual, what is the total value of the /suma facturacion/ column?

Finally, could you provide some sample data? We can better understand the problem and help you.

Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best Regards,

Dengliang Li

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

[CarlosP]

Thanks you were right! there is no additional sum if a row is duplicated. I should've checked it beforehand!