topic Re: Ouput the original value when a single option from slicer is selected, Ouput "NA" when multiple. in DAX Commands and Tips

Ouput the original value when a single option from slicer is selected, Ouput "NA" when multiple.

sobhik_saha_98 — Mon, 25 Jul 2022 09:32:52 GMT

So I am using a table visual which has multiple columns, There is this 1 column where I need to show the original value when a single option is selected and "NA" when there is a multi select in the table itself.

This is what should happen on single select-->>

col_header	col_header	col_header	Target_Col
..	..	..	0.00
..	..	..	0.81
..	..	..	0.92

This is what should happen on Multi select-->>

col_header	col_header	col_header	Target_Col
..	..	..	NA
..	..	..	NA
..	..	..	NA

Need to complete this ASAP. Any help is appreciated. Cheers.

Re: Ouput the original value when a single option from slicer is selected, Ouput "NA" when multiple.

daXtreme — Mon, 25 Jul 2022 12:16:36 GMT

Just use the HASONEFILTER function to make decisions in your DAX code.

Re: Ouput the original value when a single option from slicer is selected, Ouput "NA" when multiple.

sobhik_saha_98 — Mon, 25 Jul 2022 13:57:45 GMT

Can you share me the code or something. Not heard of it. Will be a great help. Thanks for the reply

Re: Ouput the original value when a single option from slicer is selected, Ouput "NA" when multiple.

v-yanjiang-msft — Fri, 29 Jul 2022 13:42:06 GMT

Hi sobhik_saha_98 ,

According to your description, I create a sample.

Put Column1 in a slicer, then create a measure to show Column2 when there is a single option is selected in the slicer otherwise display NA. Here's my solution, create a measure(not calculated column because it can't change by the slicer selection).

Measure = IF ( COUNTROWS ( ALLSELECTED ( 'Table'[Column1] ) ) = 1, MAX ( 'Table'[Column2] ), "NA" )

Then get the result.

You may need to tweak the formula a bit depending on your sample, but this is the basic idea.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

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