filtering a table by using a mesure (TOPN and SUMX)

[Anonymous]

Hello everyone.

I al using a mesure below to get a table with just negatives values and then i get a sum of these values ( the number of values is dynamic as i use a what if parametre). However in my table u see that i get a good total but i want to know how to filter my table so if i choose 3 in the parametre i could get only three values in my table and not ALL values.  
I created a rank column in my BASE table ( 

Rank = RANKX(BASE;BASE[ MARGE ACT];BASE[ MARGE ACT];ASC;Dense)

So i can reference this column in my measure 
 

SUMX(TOPN('Paramètre'[Valeur Paramètre];FILTER(BASE;BASE[ MARGE ACT]<=0);BASE[Rank];ASC);BASE[ MARGE ACT])

But it still doesnt work

Thanks a lot

[Stachu · Accepted solution]

try this code:

Measure =
SUMX (
    FILTER (
        BASE;
        BASE[ MARGE ACT] <= 0
            && BASE[Rank] <= SELECTEDVALUE ( 'Paramètre'[Valeur Paramètre] )
    );
    BASE[ MARGE ACT]
)

this measure will only show values for whatever is in the top, but you will still see all rows because e.g. 'Paramètre'  has value for all entries, not just the Top entries