Problem calculating the total sum of users

[Anonymous]

Hi all,

I'm having problem to get the real sum of users. I have the measure, which is the sum of users:

Users = calculate(DISTINCTCOUNT(Users[IdRegistered]); Users[IsRegistered])

Then, I want to visualize the quantity of users that visualize an event or video. Then I drag from my dimension table, the field related to the name of the event, and I get the result table:

From this table, the total result is not working properly, as the sum of the users should be 3.977 (622 + 908 + 944 + 1503). Also, I've created a new measure but I'm not getting the expected result:

Users Total = CALCULATE(COUNT(Users[IdRegistered]); Users[IsRegistered])

And this is a basic model:

I am missing something? Please help, I have tried several ways to do it but I can't get it. Thanks in advance

[Cmcmahan · Accepted solution]

The reason you're seeing a lower result in the total row for your DISTINCTCOUNT measure is because PowerBI is re-calculating the measure, but including all Events.  So I'm guessing you had ~700 people that went to multiple events.

To get the 3977 sum you're looking for, try this:

TotalUsersForTable = SUMX( ADDCOLUMNS(VALUES(Table1[Evento]), "Total People", [UsersTotal]), [Total People])