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)

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])