HELP! RANKX with TOP 5

[majid_75]

Hello,

Can you help me with my measure.

I want to filter with a slicer TOP 5, my indicator, here is my 3 measure:

- Pipe =

CALCULATE(

ta_fact[Pipe Dyn],

FILTER(

ALL(Date_),

Date_[Year]=YEAR(DATE(LEFT( SELECTEDVALUE(Date_[Yearmonth]),4),RIGHT( SELECTEDVALUE(Date_[Yearmonth]),2),1 ))

&& Date_[Yearmonth] > SELECTEDVALUE(Date_[Yearmonth])

&& Date_[Date] <= ENDOFYEAR(Date_[Date])

)

)

- RankX = RANKX(ALL(table1[Name]),[Pipe],,DESC)

- Indicator = CALCULATE([Pipe],FILTER(VALUES(ta_fact_saleslead[Owner_Name]),[Range]<=5))

I But i don't understand my problem, pls!

[amitchandak · Accepted solution]

@majid_75 , your last formula does not seem fine, are you trying to filter rank or range

Try like

Indicator = CALCULATE(sumx(values(Table[Name]),[Pipe]),FILTER(VALUES(ta_fact_saleslead[Owner_Name]),[Rank]<=5))

Or use TOPN - https://www.youtube.com/watch?v=QIVEFp-QiOk