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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , try to add filter  concatenatex

 

example, add additional values

 

Label XX =
If(NOT(ISFILTERED(ACHFB_SDM_PBI_V[ACHFB])),"All ACHFB",Concatenate("ACHFB - ",If(ISFILTERED(ACHFB_SDM_PBI_V[ACHFB]),
calculate( CONCATENATEX(VALUES(ACHFB_SDM_PBI_V[ACHFB]),ACHFB_SDM_PBI_V[ACHFB],","), filter(ACHFB_SDM_PBI_V , not ACHFB_SDM_PBI_V[ACHFB] in {"--INVALID",""$_NOT APPLICABLE,"?-UNKNOWN"} ) ) )))