Forum Discussion

augustindelaf's avatar
augustindelaf
Impactful Individual
7 years ago
Solved

display multiple elements with SELECTEDVALUE

Hello,   I am using the DAX measure SELECTEDVALUE to display the value of a column that is filtered in a table visual. But I can't find a way to display multiple elements.   For instance, if "Fr...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, augustindelaf 

    Try this formula: 

    Selected PDLs=
CONCATENATEX ( VALUES ( Data[Nationality] ) , [Nationality] , ",")

    Best Regards,

    Lin

     

  • PattemManohar's avatar
    PattemManohar
    7 years ago

    augustindelaf  Please try this in your measure..

     

    MonthSelection = 
VAR _Count = COUNTROWS(VALUES(_Date[Month]))
VAR _Concat = CONCATENATEX(VALUES(_Date[Month]),[Month],",")
RETURN IF(_Count>2,"Multiple Selection",_Concat)

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, augustindelaf 

Try this formula: 

Selected PDLs=
CONCATENATEX ( VALUES ( Data[Nationality] ) , [Nationality] , ",")

Best Regards,

Lin

 

augustindelaf's avatar
augustindelaf
Impactful Individual
7 years ago

v-lili6-msft  I also need to display "Multiple Selection" IF the Concatenex values are more than 2.

 

Than means :

1 selection = [Selection1]

2 selections =[Selection1] ", " [Selection2] 

3 sleections and more = "Multiple Selection"

 

how can I do that, please ?

  • augustindelaf's avatar
    augustindelaf
    Impactful Individual
    7 years ago
    What I did :
     
    Selected Nationality =
    IF(COUNTA( VALUES < 2;
    CONCATENATEX ( VALUES ( Data[Nationality] ) ; Data[Nationality] ; ", ")
    ;"Multiple Selection"
    ))
     
    But it does not work
    • PattemManohar's avatar
      PattemManohar
      Community Champion
      7 years ago

      augustindelaf  Please try this in your measure..

       

      MonthSelection = 
VAR _Count = COUNTROWS(VALUES(_Date[Month]))
VAR _Concat = CONCATENATEX(VALUES(_Date[Month]),[Month],",")
RETURN IF(_Count>2,"Multiple Selection",_Concat)

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Make Variable in DAX , Give any name like "My Selection" then 

        Make small dimension table (Measure Selection) with your selected Measure name and use it in DAX.

        Here is Formula : I have three measure and I made a table with three name and used in DAX

         

        DAX :


        Selected Measure:= Var MySelection = CALCULATE(ALLSELECTED('Measure Selection'[Measure Name ]))
        RETURN SWITCH( TRUE(),MySelection = "Discharge",[Discharge Count],MySelection="Admission",
        [Admission Count],MySelection="Patient Days",[Patient Days],[Discharge Count])