Solved: Re: sum measure doesn't works

sandrasanchez · ‎08-01-2016

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??

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

Thanks so much!!!

donsvensen · ‎08-01-2016

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

donsvensen · ‎08-01-2016

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 · ‎08-01-2016

thanks so much!!!

sum measure doesn't works