Sort Top 5 Incidents by Date

DAX DAX Calculations
1

Hi All,
We have a table that displays incidents by date. some of the columns are:

image
image1303×319 31.9 KB

I’m looking to display ONLY 5 of the latest incidents by date in a table visual.

I’ve tried to use the visual level filter to achieve this, But I have noticed that this has fallen apart a couple of times.

image
image1265×471 228 KB

I have not used a date table, as I’m not doing any other time intelligence.

Is there a smarter way of doing this?

Thanks

1 Like
2

@Ikay ,

There’s no such thing as doing a little bit of time intelligence. You either are or you’re not - and in this case you clearly are, so you should use a dedicated date table connected to your data model.

Then you’ll just need to write a basic RANKX measure ranking incidents by date, decide how you want to handle ties and have the measure return the ranking if less than or equal to 5, blank otherwise.

  • Brian
4 Likes
3

Hey @Ikay it will be really easy to add a Date Table into this report and get this working. Grab the eDNA Data Table, put it into your report and follow BrianJ’s RANKX suggestion, you’ll be good to go.

1 Like
4

Thanks Brian