Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have 2 columns, Week & Distinct User ID.
User ID is a Distinctcount of Users ID.
How do I sum these?
476 + 486 + 483 etc...
Solved! Go to Solution.
That's a pretty common scenario, as your measure total won't sum up the single amounts.
That happens because your distinctcount will count the distinct values when filtered by week, but on the total, it doesn't simply sum the cells, but removes the week filter (so will be a distinctcount on all weeks, hence 644).
Here's a link for you: https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/td-p/547907
The solution is basically to precalculate the table in memory, and use the summed amount (in memory) as the total.
Write a measure
Used ID SUM = SUM(TableName[User ID])
and drag it to your visual
Hi @ChandeepChhabra ,
Not exactly what I need.
I have the distinctcount of all user id's. I need to sum all these together.
That's a pretty common scenario, as your measure total won't sum up the single amounts.
That happens because your distinctcount will count the distinct values when filtered by week, but on the total, it doesn't simply sum the cells, but removes the week filter (so will be a distinctcount on all weeks, hence 644).
Here's a link for you: https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/td-p/547907
The solution is basically to precalculate the table in memory, and use the summed amount (in memory) as the total.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |