Dax formula for Selected Value plus one of non-selected value

[renjithpbi]

Hi,

I am looking for a measure to show the values of selected value from a slicer plus one of the non selected value. 

This is a sample data to explore:

Fruit	Feedback
Apple	Good
Orange	Good
Grape	Better
NA	NA

I need to show the values from Feedback column based on slection in a slicer. 

Here the slicer is Fruit Column.

The scenario is , user will select only one value from the Fruit column, eg, Apple is selected. 

so the value will be displayed as "Good".

But I want a measure to show values from Apple plus NA, but user only selected Apple.

Currently my measure is 

Measure = CONCATENATEX(VALUES('Table'[Feedback]),  'Table'[Feedback] , ", ")

Thanks in Advance

I am expecting like this

Regards

Renji

[Anonymous · Accepted solution]

Hi @renjithpbi ,

Maybe you can modify your formula like below:

Measure = 
VAR SelectedFeedback = CONCATENATEX(
    VALUES('Table'[Feedback]),
    'Table'[Feedback],
    ", "
)
VAR NAFeedback = CALCULATE(
    MAX('Table'[Feedback]),
    'Table'[Fruit] = "NA"
)
RETURN
IF(
    ISBLANK(SelectedFeedback),
    NAFeedback,
    SelectedFeedback & ", " & NAFeedback
)

Best Regards,
Adamk Kong

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

[renjithpbi]

Yes, 

Apple, NA

Orange, NA

Grape, NA

[vanessafvg]

is it always going to be NA the additional value?