Forum Discussion
DAX Filter Suggestion needed
Hi venkatnitt84
The Region Cd Slicer is a multi-select slicer, will users select more than one value for the same position? For example, select 001A and 001B at the same time? If so, do we need to display all regions whose first position value of Region Cd is A or B?
Besides, I see 003 and 004 in the slicer, will there be 005, 006, ... in the slicer? How many values will be selected at the same time? Will users select multiple values at uncontinuous positions, e.g. 001A & 004F?
It becomes more complicated when thinking of more conditions.
Regards,
Community Support Team _ Jing
Hi , Thank you for your reply and below is my response to your questions
1) yes region cd is multiselect , same position cannot have more than 1 value. For eg. if user selects 001 and 001B, No records will be return. This is invalid scenario as the criertia is "AND" condition and no single record will have A and B as value.
2) There are 200 positions (001A to 200XX" ) . But Users can select maximum of 5 values in the slicer.
say if user selects "001A" and "003B" and "005Z" , then i need to display all records where the 1 position value is A and 3 position value is B and 5 position value is Z.