Can you help me with my measure.
I want to filter with a slicer TOP 5, my indicator, here is my 3 measure:
- Pipe =
- RankX = RANKX(ALL(table1[Name]),[Pipe],,DESC)
I But i don't understand my problem, pls!
Go to Solution.
@majid_75 , your last formula does not seem fine, are you trying to filter rank or range
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
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.