Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I would like to ..
Obtain the total count of blank values in Column A
These are true blank values.
Obtain the total count of blank values in Column B
Then add the values. and store the Total in a new field.
So far I have done the following, however not sure if this is best practice.
CountBlankSystem1EmployeeID = COUNTBLANK('Table'[System 1 Employee ID])
Column Formatted as Whole Number
Returns the number 39
CountBlankSystem2EmployeeID = COUNTBLANK('Table'[System 2 Employee ID])
Column Formatted as Whole Number
Returns the number 17
Now I need to work out how to add the values of 39+17 = 56
Note these totals will update with new data uploads from Excel.
TIA
@dd88 , Create a new measure
[CountBlankSystem1EmployeeID] +[CountBlankSystem2EmployeeID]
or create a measure
countows(filter(Table, isblank('Table'[System 1 Employee ID])) || isblank('Table'[System 2 Employee ID])) ) )
and another question is ..
I currently have the following counts for
Total Mismatches = 4
TotalBlank EmployeeID System 1 = 1
TotalBlank EmployeeID System 2 = 1
The last count to workout is total mistmatches. ie (EmployeeID System 1 is not blank) AND (EmployeeID System 2 is not blank) = 2
How can I achieve this?
Create a new calculated column, new measure?
Eg Total Mismatches – (TotalBlank EmployeeID System 1 - TotalBlank EmployeeID System 2)
Note: ideally there is a unique employeeID that is the key. Unfortunately the data is from active legacy separate systems. I am performing a data clean-up across both systems. To do data migration/ preparation into a new system which will have a unique employeeID.
An example data set is
TIA
Many thanks @amitchandak
I used your suggestion Option 1
Create a new calculated column
Total = [CountBlankSystem1EmployeeID] +[CountBlankSystem2EmployeeID]
And it worked! Many thanks again ..
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
81 | |
67 | |
62 | |
46 | |
45 |