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.
Hi,
Im workin on a requirement that...
Requirement:
From the above table i want to get the participant name who did not attempeted the test( the value for respective columns is empty).
All the above columns(Domains--1.Introduction,2.,3.,..........12.Mock (ALL THESE ARE DIFFERENT COLUMNS)) are of whole number except Participant Name.
Outcome:
I want a list of participant names who didnt attend the test in all the respective domains.
@Dheeraj ,
Use ALLNOBLANKROW
if (ALLNOBLANKROW(Table)+0 =0,1,0), if the visual or summarize you take this measure by the candidate that will candidate has not given any exam
COUNTBLANK(Table[Exam name]) will candidate count not given exam
@Dheeraj I would highly recommend unpivoting your columns by right-clicking on Participant column and then choosing Unpivot other columns. Then this should be fairly trivial. Otherwise, you will need to use something like MC Aggregations - https://community.powerbi.com/t5/Quick-Measures-Gallery/Multi-Column-Aggregations-MC-Aggregations/m-...
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |