Forum Discussion
filtering a table with topn
Hello
Can please someody help me to resolve a problem : i get a table but when i use my if parametre to filter it i get all values and not filtered
I use this measure :
SUMX(TOPN('Paramètre'[Valeur Paramètre];BASE;BASE[Rank];ASC);BASE[ MARGE ACT])
And in my BASE table i created a Rank column to reference it in my measure (
And in my BASE table i created a Rank column to reference it in my measure (
Rank = RANKX(BASE;BASE[ MARGE ACT];BASE[ MARGE ACT];ASC;Dense)
5 Replies
- amitchandak
Super User
Try like
var _max =max('Paramètre'[Valeur Paramètre]) // var _max =maxx('Paramètre','Paramètre'[Valeur Paramètre]) SUMX(TOPN(_max;BASE;BASE[Rank];ASC);BASE[ MARGE ACT])Thanks but it doesnt work
the same effect
here is a link to download a pbi file = http://www.filedropper.com/pizdosyaSo i could find a solution as i suppose ( not sure 😃 ) by using a measure :
CALCULATE(SUMX(TOPN('Paramètre'[Valeur Paramètre];BASE;BASE[Rank];ASC);BASE[ MARGE ACT]);FILTER(BASE;BASE[ MARGE ACT]<=0&&BASE[Rank]<='Paramètre'[Valeur Paramètre]))
NOW the issue is that i cant filter by years : on my screens u see that while year filter inst applied i get all 4 values in my table however when i choose a year i get only two, however i would like to get all 4 values but for a selected year ? What do you think about it ?Thanks
