cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sandrasanchez Regular Visitor
Regular Visitor

sum measure doesn't works

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_ProductURLNúmero de Usuarios
https://emprion.2
https://gfp4
https://saznn219
https://sddff23
https://formaci11

https://hospitalesbio

Total

2

246

 

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

Thanks so much!!!

 

1 ACCEPTED SOLUTION

Accepted Solutions
donsvensen Member
Member

Re: sum measure doesn't works

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

2 REPLIES 2
donsvensen Member
Member

Re: sum measure doesn't works

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 Regular Visitor
Regular Visitor

Re: sum measure doesn't works

thanks so much!!!