Forum Discussion
DoctorYSG
2 years agoHelper III
TOPN() for Netsted Table?
I am looking to pull the top 100 users by usage out of this Summary table. So there is going to be way more than 100 rows, since each of the top 100 users are going to have nested rows with other information. Is there a way to do this? TOPN seems to just get the top N rows:
User Usage =
VAR sumTable =
SUMMARIZE(
Telemetry,
NodeInfo[UserTitle],
NodeInfo[Application],
NodeInfo[OS_DISK_TYPE],
NodeInfo[DEVICE_MEMORY],
NodeInfo[EITaaS],
NodeInfo[Web],
"WaitTime", CALCULATE(SUM('Telemetry'[WaitTime]) / (60 * 60 * 1000), 'Telemetry'[Used]),
"UsedTime", CALCULATE(SUM('Telemetry'[UsageTime]) / (60 * 60 * 1000), 'Telemetry'[Used])
)
RETURN
TOPN(10000,
sumTable,
[UsedTime], DESC
)
1 Reply
- MFelixSuper User