Display multiple values with selectedvalue

[sagarsahoo_123]

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

[TomMartens · Accepted solution]

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]

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

[sagarsahoo_123]

Hi @TomMartens ,

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

Regards,

Sagar