Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |