Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

dynamically result label

Hi ,   I want to dislplay selected filters/selections made by User in a textbox. In order to achieve this I have used below query Label XX = If(NOT(ISFILTERED(ACHFB_SDM_PBI_V[ACHFB])),"All ACHFB"...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    I created a sample pbix file(see attachment) for you, please check whether that is what you want. You can create a measure as below:

    Label XX = 
IF (
    ISFILTERED ( 'ACHFB_SDM_PBI_V'[ACHFB] ),
    CONCATENATEX (
        FILTER (
            VALUES ( 'ACHFB_SDM_PBI_V'[ACHFB] ),
            NOT ( 'ACHFB_SDM_PBI_V'[ACHFB]
                IN { "- - INVALID", "$ - NOT APPLICABLE", "- NOT AVAILABLE", "? - UNKNOWN" } )
        ),
        'ACHFB_SDM_PBI_V'[ACHFB],
        ","
    ),
    "All ACHFB"
)

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

I created a sample pbix file(see attachment) for you, please check whether that is what you want. You can create a measure as below:

Label XX = 
IF (
    ISFILTERED ( 'ACHFB_SDM_PBI_V'[ACHFB] ),
    CONCATENATEX (
        FILTER (
            VALUES ( 'ACHFB_SDM_PBI_V'[ACHFB] ),
            NOT ( 'ACHFB_SDM_PBI_V'[ACHFB]
                IN { "- - INVALID", "$ - NOT APPLICABLE", "- NOT AVAILABLE", "? - UNKNOWN" } )
        ),
        'ACHFB_SDM_PBI_V'[ACHFB],
        ","
    ),
    "All ACHFB"
)

Best Regards