Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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])
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])
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
79 | |
63 | |
61 | |
59 |
User | Count |
---|---|
166 | |
114 | |
100 | |
73 | |
66 |