Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Data set (Table name - Table1) has the insurance complaints inforamtion. I am trying to get the top 10 days where maximum complaints have been filed.
Below is the DAX query result. Its not sorted correctly. Can anyone tell what going wrong?
Solved! Go to Solution.
TOPN does not guarantee any sort order for the results.
If you're writing a DAX query, you can add and ORDER BY clause at the end. For example,
EVALUATE
TOPN (
10,
SUMMARIZECOLUMNS (
Table1[Received date],
"Complaint Count", COUNTROWS ( Table1 )
),
[Complaint Count], DESC
)
ORDER BY [Complaint Count] DESC
TOPN does not guarantee any sort order for the results.
If you're writing a DAX query, you can add and ORDER BY clause at the end. For example,
EVALUATE
TOPN (
10,
SUMMARIZECOLUMNS (
Table1[Received date],
"Complaint Count", COUNTROWS ( Table1 )
),
[Complaint Count], DESC
)
ORDER BY [Complaint Count] DESC
That worked. Thanks.
If I need to show this in report view, how do I do that?
Then you probably don't need any DAX. Just put the columns in a table visual, add a TopN filter in the filter pane, and sort by whichever one you want.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 9 | |
| 4 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 13 | |
| 9 | |
| 8 | |
| 8 | |
| 7 |