Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
  • v-juanli-msft's avatar
    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.