Filter the values on a table

[Tenuki]

Hello, 

I have create a top 5 items by % margin.

I get this result :

Item           %Marg       Revenue2025     Revenue2024

Item 1        1050 %       1050             1

Item 2        300 %          9                   3

...
I would like to filter revenue, in order to display the top 5 items witch have a revenue2 > 1500 for instance. 

I try data manipulation but it didn't work. 

My revenue mesure look like this :

sum({<YearRevenue={$(=Num(YEAR(Today())))}>} Revenue)

Many thanks for your help

[robert_mika · Accepted solution]

You can define your values in script and then use as dimension

LET vCurrentYear = Year(Today());

RevenueTable:
LOAD
*,
IF(YearRevenue = $(vCurrentYear), Revenue, 0) AS RevenueThisYear
FROM [YourDataSource];

AggregatedRevenue:
LOAD
Sum(RevenueThisYear) AS TotalRevenueThisYear
RESIDENT RevenueTable;

The add to your main table with a join

[Tenuki]

Many thanks !