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(),
Selection = "Scanning Time",[rTotal Amt Scanned / rTotal Hours Scanned],
Selection = "Clocking Time",[rTotal Amt Scanned / rTotal Hours Clocked],
[rTotaal Uren Probis Time] )

 

This measure is put into a graph with dates, and using filters, the user can see the average scans per hour for a certain person, based on clocking or scanning time. Now, I would like to make it so that when they select both, it shows both average per hour scanned and average per hour clocked.

 

Can anyone help me with this please?

 

Thanks!

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

2 Replies

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