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

[sobhik_saha_98]

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.

[v-yanjiang-msft · Accepted solution]

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.

[sobhik_saha_98]

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

[daXtreme]

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