cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
majid_75
Frequent Visitor

HELP! RANKX with TOP 5

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!

pbi.PNG

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

1 REPLY 1
amitchandak
Super User IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.