Need help for Dynamic Slicer to return the text data

[shikha3107]

Hello Everyone,

I have been working on Human Resource project and come across one issue. I wanted to retrieve the result from the associated candidate, role tables once slicer value is chosen.

I have a slicer that has 4 values for the role of candidate.

Software Dev

Data Analyst

Test Analyst

Web Designer

Tables:

Candidate                                           Role                                                              Fact_Profile

CKey          Name                             Rkey         RName                               FKey           CKey                  RKey

1                 Shikha                              1           Soft Dev                               1                   1                       3

2                  Adi                                  2           Test Analyst                         2                   2                       2

3                Ajay                                  3             Data Analyst                       3                   3                      2

4                Kim                                   4             Web Designer                    4                   4                       1

5                 Jing                                                                                            5                   5                       3

Desired Output: Once I choose any one part of slicer so the related value should be visible in Power BI. But after trying lots of option I am unable to write a DAX for that. 

Ex: If select Data Analyst from the slicer then given below result is required. 

Table:

Name            Role

Shikha            Data Analyst

Jing                Data Analyst

 Any help would be appreciated.

Thanks

Shikha

[v-lionel-msft · Accepted solution]

Hi @shikha3107 ,

Like this?

It seems that DAX is not needed, only need to establish the table relationship.

Please refer to my .PBIX file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lionel-msft · Accepted solution]

Hi @shikha3107 ,

Has your problem been solved?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lionel-msft · Accepted solution]

Hi @shikha3107 ,

Like this?

It seems that DAX is not needed, only need to establish the table relationship.

Please refer to my .PBIX file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.