Forum Discussion
display multiple elements with SELECTEDVALUE
hi, augustindelaf
Try this formula:
Selected PDLs= CONCATENATEX ( VALUES ( Data[Nationality] ) , [Nationality] , ",")
Best Regards,
Lin
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)
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)
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])Hi Anonymous
it is an old request that I made,
i don't remember the use case it was necessary for.
Anyways, thank you.
PattemManohar thanks for the reply !
i think it works but I used another formula :
Many thanks anywayLabel - Selected Nationality = IF( COUNTROWS( VALUES( Data[Nationality] ) ) <3 ; CONCATENATEX(VALUES( Data[Nationality] ); Data[Nationality]; ", " ) ; "Multiple Selection" )it works fine, thank you!
How do I display "All Months" when all or none of the months are selected?
Not working when selectint single value for me
