Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi community,
I am quite new in Power BI and DAX. Currently I generated a table that shows in which month, which api has which exception and the total count for that exception. A typical data is like this:
April , user/getresource, SystemException, 4000.
So there are 4 columns, month, api, exception and the count for that exception. the table is a little bit big. Is there any way that I can only show the top 3 exceptions per month and per api? like in April, there are 12 kind of exceptions happened for user/getresource, but I only want to show top 3 exceptions.
Really thank you for your help!
Solved! Go to Solution.
You may refer to the following DAX that creates a new table.
top 3 = FILTER ( Table1, RANKX ( CALCULATETABLE ( Table1, ALLEXCEPT ( Table1, Table1[month], Table1[api] ) ), Table1[count], , FALSE (), DENSE ) <= 3 )
You may refer to the following DAX that creates a new table.
top 3 = FILTER ( Table1, RANKX ( CALCULATETABLE ( Table1, ALLEXCEPT ( Table1, Table1[month], Table1[api] ) ), Table1[count], , FALSE (), DENSE ) <= 3 )
Really thank you, this is what I want
Hi Community,
I am quite new with Power BI and DAX and need some help to deal with table. Really thank you if you can help.
I currently have a table that four columns, Month, API, exception and count, one row is like this:
May user/getResource System.Exception 4000
This row means that in May, for API named user/getResource, exception named System.Exception happened 4000 times. Currently I generated a table that shows all exceptions, but there are too many kind of exception and some of them happened less than 10 times per month which are not quite important.
So my question is, how can I only show the top 3 exceptions per month and per API in the table?
Really thank you for your help!
Thanks,
Peter
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |