how can I show top 3 data with a combined categories?

[geeksforfun]

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!

[v-chuncz-msft · Accepted solution]

@geeksforfun,

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
)

[geeksforfun]

Really thank you, this is what I want

[geeksforfun]

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