Using SelectedValues to show in Name Card

[hhasmin]

Hi Everyone!

I hope somebody can help me with this problem. 

I am have 2 slicers from 2 different tables

QA[Agent Name] - returns the agent name

QA Summary[Cycle] = returns what cycle the agent was evaluated from

What I want to achieve is to show in the Name Card Visual the agent's overall mastery level in a particular cycle.

example:

Agent Name        Cycle              Overall Mastery Level

Jane Doe                2                         Effective

James Smith           2                         Advanced

of course dragging the column 'overall mastery' in the name card visul wont work because it doesnt change the value whenever I select a different agent or cycle.

Please help!

[v-diye-msft]

Hi @hhasmin 

Do you have a dummy pbix or simple worksheet?

[Nathaniel_C]

Hi @hhasmin ,

Where is the mastery level located?

Nathaniel

[hhasmin]

Hi Nathiel,

the table is QA Summary[Cycle]

[Nathaniel_C]

Hi @hhasmin ,

So it is on the same table as one of your slicers. Is there a relationship between the two tables? If not could there be? If there is no possible way to link them, you may have to create an interrmediate table or add a column to one of the tables. For example, is there a unique identier number, like employe id in the employee table? You could then add a column in the Summary table with that column such as EID, then relate the two tables. 

@If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[hhasmin]

I am not sure if this correct. I've tried that however it returns all the value available in Overall_Mastery_c

Cycle[c] is the QA cycle, example Cycle 1, Cycle 2, Cycle 3

Overall mastery c is the score of each agent= advanced, expert, or effective

So if I select Cycle 1 and Agent 1, I want to show what is the Overall Master Level for that agent.

I created a column, please see below

slicer mastery =
VAR s = VALUES('QA Feedback Summary'[Cycle__c])
VAR m = VALUES('QA Feedback Summary'[Overall_Mastery__c])
VAR c = COUNTROWS(ALL('QA Feedback Summary'[Overall_Mastery__c])) = COUNTROWS(s)
RETURN
IF(
    s, "All Selected",
    CONCATENATEX(
        m,
        'QA Feedback Summary'[Overall_Mastery__c],
        "; "
    ))

[Nathaniel_C · Accepted solution]

Hi @hhasmin ,

If I understand correctly Cycle and Mastery are on one table joined to an Emp table.

So, I did a quick input tables and visuals. Is this what you are looking for in the visuals?

Just dragged the columns for the slicers, and the columns for the table.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

This is nothing selected.

This is Felicia Cycle 2 selected

Emp table

Mastery table

1 to many relationship

[hhasmin]

Hi Nathaniel, 

There is already a relationship between two tables. I am just now sure what syntax to use so that when I select say Cycle 2 on the slicer, it will show what is the Mastery level of the agent.