Forum Discussion

sagarsahoo_123's avatar
sagarsahoo_123
Helper 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
Super 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
    Helper IV
    3 years ago

    Hi TomMartens ,

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

     

    Regards,

    Sagar

  • Nieczytelny's avatar
    Nieczytelny
    New Member
    2 years ago

    Hi All,

     

    Let me refresh the topic. Just no to create new one.

     

    I've got similar situation...

    Formula counts Open Cases at each day in the past.

     
    WIP =
    CALCULATE (
        COUNT ( 'vwSupplier_Feedback'[_Identifier] ),
        FILTER(
            ALL ( 'vwSupplier_Feedback' ),
                [_PPG_Location] = SELECTEDVALUE('vwSupplier_Feedback'[_PPG_Location])
                && [_Issued_Date]<= SELECTEDVALUE ( 'Calendar'[Date] )
                && or( [_Resolved] >= SELECTEDVALUE ( 'Calendar'[Date].[Date] ) , [_Resolved] = BLANK() )      
                )
        )
     

     

    I have got a slicer so I can select a "_PPG_Location" to see Open Cases for the selected Location. The graph works perfectly with single location. But if I wanted to select multiple Locations, it is not working anymore.I think I understand why, but have no idea how to allow mulptiple selections.

     

    I'll appreciate any help.

     

    M