Forum Discussion
Anonymous
6 years agoNot applicable
Selected value with multiple results
Hello everyone, I have an issue with the following measure: rMeasure Selection = VAR Selection = SELECTEDVALUE('Selection Measure'[Selection Measure], "All") Return SWITCH(true(), Selec...
- 6 years ago
Hi Anonymous
Create a measure
Measure final = VAR s2 = CONCATENATEX ( 'Table (3)', 'Table (3)'[selection], "," ) RETURN SWITCH ( TRUE (), s2 = "select1", [Measure], s2 = "select2", [Measure 2], s2 = "select1,select2", [Measure 3] )Or
Measure 4 = VAR s2 = CONCATENATEX ( 'Table (3)', 'Table (3)'[selection], "," ) RETURN SWITCH ( TRUE (), s2 = "select1", FORMAT([Measure],"General Number"), s2 = "select2", FORMAT([Measure 2],"General Number"), s2 = "select1,select2","select1:"&FORMAT([Measure],"General Number")&" ,"&"select2:"&FORMAT([Measure 2],"General Number") )Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-juanli-msft
6 years agoCommunity Support
Hi Anonymous
Create a measure
Measure final =
VAR s2 =
CONCATENATEX (
'Table (3)',
'Table (3)'[selection],
","
)
RETURN
SWITCH (
TRUE (),
s2 = "select1", [Measure],
s2 = "select2", [Measure 2],
s2 = "select1,select2", [Measure 3]
)
Or
Measure 4 =
VAR s2 =
CONCATENATEX (
'Table (3)',
'Table (3)'[selection],
","
)
RETURN
SWITCH (
TRUE (),
s2 = "select1", FORMAT([Measure],"General Number"),
s2 = "select2", FORMAT([Measure 2],"General Number"),
s2 = "select1,select2","select1:"&FORMAT([Measure],"General Number")&" ,"&"select2:"&FORMAT([Measure 2],"General Number")
)
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.