Forum Discussion

sandrasanchez's avatar
sandrasanchez
Icon for Advocate I rankAdvocate I
10 years ago
Solved

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

 

  • donsvensen's avatar
    donsvensen
    10 years ago

    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

  • donsvensen's avatar
    donsvensen
    Icon for Skilled Sharer rankSkilled Sharer
    10 years ago

    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