Forum Discussion
Solved
Override normal slicer behavior
So I have a sales data and it can be filtered by organization or industry (each organization has an industry). Now if I have a slicer for organization, I can select an organization and it will filter...
Hi RingoMoon ,
Here are the steps you can follow：
1. Create measure.
Rank = RANKX( FILTER(ALLSELECTED('Industry table'),'Industry table'[Org_ID]=MAX('Industry table'[Org_ID])&&'Industry table'[Industry Name]<>"Other"), CALCULATE(MAX('Industry table'[Industry Name])),,ASC)Flag = var _select=SELECTEDVALUE('Organization table'[Name]) var _ID=MINX(FILTER(ALL('Organization table'),'Organization table'[Name]=_select),[ID]) var _min=MINX(ALLSELECTED('Industry table'),[Rank]) return IF( MAX('Industry table'[Org_ID])=_ID&&[Rank]=_min&&MAX('Industry table'[Industry Name])<>"Other",1,0)2. Result:
When there are both Other and other values in [Industry Name], the smallest of the values other than Other is displayed:
When [Industry Name] is only Other, nothing is displayed:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
