Selected value with multiple results

[Anonymous]

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!

[v-juanli-msft · Accepted solution]

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.

[lbendlin]

What does [rTotaal Uren Probis Time] represent?