Forum Discussion
Clustered Column Based on Criteria
Tweaked it to exclude rows from showing final rank:
Top 10 within range only =
var matchingrows =
Filter(AllSelected(table), [YTD%]>= 0.45 && [YTD%]<= 1 && [YTD margin]>= 2000 && [YTD margin]<= 1000000)
var curr = [YTD%]
Return
if(
[YTD%]>= 0.45 && [YTD%]<= 1 && [YTD margin]>= 2000 && [YTD margin]<= 1000000,RankX(matchingrows , [YTD%],,Desc, Skip)
,BLank()
)Add this into the visual to check it works and then use it as a filter 🙂
i forgot to mention the YTD Margin and YTD% are both measures. so i tried the dax but i couldn't see these 2.
Super UserTweaked it to exclude rows from showing final rank:
Top 10 within range only =
var matchingrows =
Filter(AllSelected(table), [YTD%]>= 0.45 && [YTD%]<= 1 && [YTD margin]>= 2000 && [YTD margin]<= 1000000)
var curr = [YTD%]
Return
if(
[YTD%]>= 0.45 && [YTD%]<= 1 && [YTD margin]>= 2000 && [YTD margin]<= 1000000
,RankX(matchingrows , [YTD%],,Desc, Skip)
,BLank()
)
Add this into the visual to check it works and then use it as a filter 🙂