Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |