Get he fields and Check for each individual field selected in Multi select filter

[Anonymous]

Hi All,

I have a multi select filter of countries.

Is there any way through which I can check another condition for the selected items individually

For Ex:  Currently germany, Italy and India are selected

So, I need to get the values selected  (Germany, India, Italy )and check a condition on the values individually based on the selected values

Like this condition  :  (value of Germany is blank or value of Italy is blank or Value of India is blank) seperately.

This condition for checking blank will b dynamically based on the selected countries in the filter.

Any help?

[v-easonf-msft]

Hi， @Anonymous 
Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

@v-easonf-msft  Yes It is solvd. I used CONCATENX  and VALUE function to get the selcted values combined in a text and then usd IFERROR and SEARCH function to chck for the selecte values using IF ELSE statements

[DavisBI]

Hi, @Anonymous 

Try this:

Filter_Test = 
VAR Filters_Limit = 5
RETURN
   IF ( 
   ISFILTERED ( 'Table'[Column1] ), 
   VAR ___f = FILTERS (  'Table'[Column1] ) 
   VAR ___f2 = EXCEPT(ALL('Table'),___f)
   VAR ___t = TOPN ( Filters_Limit, ___f,  'Table'[Column1])
   VAR ___t2 = TOPN ( Filters_Limit, ___f2,  'Table'[Column1])
   VAR ___d = CONCATENATEX ( ___t,  'Table'[Column1], ", " )
   VAR ___d2 = CONCATENATEX ( ___t2,  'Table'[Column1], ", " )
   VAR ___x = "[Selected]: " & ___d 
   VAR ___X2 = "[Blank]: " & ___d2
   RETURN ___x & UNICHAR(13) & UNICHAR(10) & ___X2   
)

Result as shown below:

Mark this post as solution if this helps, thanks!