Forum Discussion

hhasmin's avatar
hhasmin
Frequent Visitor
6 years ago
Solved

Using SelectedValues to show in Name Card

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 a...
Need Help
Show and Tell
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    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

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

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's avatar
hhasmin
Frequent Visitor
6 years ago

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's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    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