Table with Ultime N

[riccardotesti76]

Dear All

I have a table with data with following information

Aging and FW (fiscal week)

Considering that I have about 100 value of Aging for each FW.

I need to view only the first 5 Top aging of the last FW (in term of last time)

I found that we can use only one Prime Filter instead of in my case I need to use two prime filter for the same table.

Do you know if we can have an alternative solution?

Thanks

Regards

[rajendraongole1 · Accepted solution]

Hi @riccardotesti76  - If you prefer to pre-calculate the filtered data, you can create a calculated table

Top 5 Aging Latest FW =
TOPN(
5,
FILTER(
'YourTable',
'YourTable'[FW] = MAX('YourTable'[FW])
),
'YourTable'[Aging],
DESC
)

 you can use this table in your visualization, Hope this works

[riccardotesti76]

Fantastic!!! You suggested a formula that I can customized for several issue!!!

Thanks