Forum Discussion

sagarsahoo_123's avatar
sagarsahoo_123
Icon for Helper IV rankHelper IV
3 years ago
Solved

Display multiple values with selectedvalue

Hi Team, Request for your support to resolve the displaying issue with selected value. I have written the code for this. But for non-selection, it is not displaying message which i want.   Here my...
Need Help
  • TomMartens's avatar
    TomMartens
    3 years ago

    Hey sagarsahoo_123 ,

    you have to incorporate the DAX function ISFILTERED in your DAX statement: ISFILTERED – DAX Guide

    Then your measure will look like this:

    Measure = 
IF( ISFILTERED( 'DimStore'[StoreName] )
    , SELECTEDVALUE( 'DimStore'[StoreName] , "Multiple Selection" ) 
    , "All"
)

    The result - the bottom right card visual is the important one:


    The top right card only contains a simple measure for illustrative purposes.

     

    Hopefully, this provides an idea of how to tackle your challenge.

     

    Regards,

    Tom

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
3 years ago

Hey sagarsahoo_123 ,

you have to incorporate the DAX function ISFILTERED in your DAX statement: ISFILTERED – DAX Guide

Then your measure will look like this:

Measure = 
IF( ISFILTERED( 'DimStore'[StoreName] )
    , SELECTEDVALUE( 'DimStore'[StoreName] , "Multiple Selection" ) 
    , "All"
)

The result - the bottom right card visual is the important one:


The top right card only contains a simple measure for illustrative purposes.

 

Hopefully, this provides an idea of how to tackle your challenge.

 

Regards,

Tom

sagarsahoo_123's avatar
sagarsahoo_123
Icon for Helper IV rankHelper IV
3 years ago

Hi TomMartens ,

Thanks a lot for your quick support. It realy helped to resolve the issue.

 

Regards,

Sagar