sum measure doesn't works

[sandrasanchez]

Hi everybody,

I have a report with a measure:

Número de Usuarios = DISTINCTCOUNT(mks_customerproductuserSet[Usuario])

If I put a table with this measure, the total row doesnt make sense, why??

mks_ProductURL	Número de Usuarios
https://emprion.	2
https://gfp	4
https://saznn	219
https://sddff	23
https://formaci	11
https://hospitalesbio Total	2 246

Total should be : 2 + 4 + 219 + 23+11+2 = 261

Thanks so much!!!

[donsvensen · Accepted solution]

Hi,

Your measure will return the distinctcount of your field at the total level as well.

So if the [Ususraio] field contains the same name in diffent URL then it will count as 1 at the total level and not 2

You have to modify your measure to act differently at total level if you want another result.

br

Erik

[sandrasanchez]

thanks so much!!!