Forum Discussion

dokat's avatar
dokat
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Update text field based on slicer selection

Hi,

 

I have a text field where i'd like it to update based on slicer selection. I have below code where if the slicer selection is "Select all" return "Dairy" however code is not working correctly. It doesnt return error but blank. Appreciate any help modifying code. Thanks

 

 

Test Measure = 
If(
    SELECTEDVALUE('POS'[Category])="Select all",
    " Dairy",
    BLANK()
    )

  

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    dokat , Sorry my mistake. Try

    Test Measure =
    If( not(isfiltered('POS'[Category])),
    " Dairy",
    BLANK()
    )

4 Replies

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

    dokat , Try isfiltered

    Test Measure = 
If(
    not(isfiltered('POS'[Category]))="Select all",
    " Dairy",
    BLANK()
    )

     

    • dokat's avatar
      dokat
      Icon for Post Prodigy rankPost Prodigy
      4 years ago

      amitchandak Thank you for your response. I tried the code however it return below error. Please see below screenshot.

       

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

        dokat , Sorry my mistake. Try

        Test Measure =
        If( not(isfiltered('POS'[Category])),
        " Dairy",
        BLANK()
        )