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 requirement is i want to display the elements based on Slicer selection.

If i am selecting one value from slicer, it will show the same, but for more than one selection, it will display "Multiple Selection" .

Upto this my code is working but i want to display "All" for no selection in slicer. It is not displaying "All".

 

Please find the code which i have written below.

L4Name = "L4_DESC: " & FORMAT(SELECTEDVALUE(VW_NIPPON_PRODUCTIVITY[L4_DESC],"Multiple Selection"),"All")
 
I have used the L4_Desc in slicer, and it is coming fine upto single and more than one selection. But for non-selection, i am expecting to display "All" . It is not working for that. 
Please support in this regard.
 

If you look at the above image, here in the L4_Desc slicer there is no selection, but in the L4_DESC card below , it is showing " Multiple Selection" but i was expaecting "All" in that. But if i select more than one in the L4_Desc slicer, the message is coming correctly like "Multiple Selection"...

 

Please help to resolve this.

 

Regards,

Sagar

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

3 Replies

  • 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

    • 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