Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

replace value for a certain slicer selection

Dear all,   I have the following situation: I have item 1 of product class A and want to compare it to other items. I have a slicer to select product classes for the compare items with the option...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    Please create a measure as below to work on it.

    Measure = 
VAR se =
    SELECTEDVALUE ( 'Table'[Option] )
RETURN
    IF (
        NOT ( ISFILTERED ( 'Table'[Option] ) ),
        BLANK (),
        IF ( se = "Automatic", "A", CONCATENATEX ( 'Table', 'Table'[Option], "," ) )
    )

     

    Pbix as attached.

     

     

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Please create a measure as below to work on it.

Measure = 
VAR se =
    SELECTEDVALUE ( 'Table'[Option] )
RETURN
    IF (
        NOT ( ISFILTERED ( 'Table'[Option] ) ),
        BLANK (),
        IF ( se = "Automatic", "A", CONCATENATEX ( 'Table', 'Table'[Option], "," ) )
    )

 

Pbix as attached.