Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Employee_ID | FULL_NAME | Clearance_Type |
101 | Amy Lu | Secret |
102 | Joe Boy | Polygraph |
102 | Joe Boy | Secret |
103 | Sam Jack | Confidential |
103 | Sam Jack | Confidential |
103 | Sam Jack | Confidential |
104 | Tom Smith | Secret |
104 | Tom Smith | Confidential |
105 | Ann Wilson | Secret |
106 | Mark Brown | Secret |
106 | Mark Brown | Secret |
107 | Jane Doe | Polygraph |
107 | Jane Doe | Secret |
107 | Jane Doe | Polygraph |
108 | Tim Bark | Confidential |
108 | Tim Bark | Secret |
108 | Tim Bark | Polygraph |
109 | May Alec | Confidential |
I Need to create a table visual showing the result below. I have tried multiple codes but none works. What query/measure should I be using?
Please note that employee_ID 103 & 106 were duplicated, but the clearance type is still only one type "Confidential".
Employee_ID | FULL_NAME | Clearance_Type |
101 | Amy Lu | Secret |
103 | Sam Jack | Confidential |
105 | Ann Wilson | Secret |
106 | Mark Brown | Secret |
109 | May Alec | Confidential |
Solved! Go to Solution.
you can try to create a column
Proud to be a Super User!
This worked! Thanks so much 🙂
you are welcome
Proud to be a Super User!
Hi,
This measure works
Measure = if(DISTINCTCOUNT(Data[Clearance_Type])=1,MIN(Data[Clearance_Type]),BLANK())
Thanks, for some reason. I am getting this error.
You are welcome. I cannot comment unless i see the file.
you can try to create a column
Proud to be a Super User!