Dax Measure is not working

[Pavithran23]

I need a help with dax measure 

Issue

Hi mam/sir currently working on oynx data project having one issue cant able to find the problem can you kindly look into it on your free time it would be really helpful - problem - trying to filter the table rows based on selected filter value for top and bottom its working but if i select another visual bottom ranking is not working for top its working fine. Attaching the images below. Thanking you in advance

[Anonymous · Accepted solution]

Hi @Pavithran23 

You can try the following solution.

1.Replace the ALL() function to ALLSELECTED() function in the measure.

2.Add calculate() funciton in the dax.

e.g 

Ranking = 
var _top=RANKX(ALL('Insurance Plicies'[ID]),CALCULATE([Total Claim Account]),,DESC)
var _bottom=RANKX(ALL('Insurance Plicies'[ID]),CALCULATE([Total Claim Account]),,ASC)
return IF([SelectedRankType]"Bottom",_bottom,_top)

If the information above cannot meet your requirements, can you offer some sample data or file so that can provide more suggestion for you.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.