Forum Discussion
Trouble creating top 10% table
Hi eire23452 -there might be a simpler approach that ensures you capture exactly the top 10% without running into the issue of including more rows than expected.You can calculate the total consumption of the top users with this measure
create new tables
Power users =
FILTER(
active_users_all,
active_users_all[Minutes Video Consumed] >= [Power users threshold]
)
You can calculate the number of users in this top 10% group by using a measure
as it is you calculated;
Power Users Count =
COUNTROWS(Power users)
Power Users Total Consumption =
SUMX(Power users, Power users[Minutes Video Consumed])
The average watch time for this top 10% group can be calculated
Power Users Average Consumption =
AVERAGEX(Power users, Power users[Minutes Video Consumed])
If this approach does not fix the issue, it may help to review the dataset and ensure there are no unintended filters or relationships that might be affecting the calculations.
hope this works
Thank you for your reply! For some reason, when I create the Power Users table with the FILTER function as suggested, it doesn't work. It just returns all of the rows for some reason (nothing is filtered).