Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am making quite a few matrix tables similar to the one below. I want to replace the blank fields with '0'. However, when I try to use different calculated measures, nothing happens or I get an error.
'
1) Number of Faculty = IF(CALCULATE(ISBLANK(COUNT('FT-cal-acad-faculty only'[Faculty Rank]))),0,COUNT('FT-cal-acad-faculty only'[Faculty Rank])). nothing happens
Your 2nd measure is missing the ) after the +0. But why can't you just use this expression?
NewMeasure = COUNT('FT-cal-acad-faculty only'[Faculty Rank]])+0
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Its giving me the error 'A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed'
When i posted before, someone told me to create a separate table and then use it in this measure. here's the table i created (called Replacing 0's) which I reference at the end of the measure you corrected for me :
I'm not sure if this separate table is needed and if I can just use a measure referencing my main dataset (i.e. is there a way to not use the 'Replacing 0's table)?
try
measure =
IF (
ISBLANK ( COUNT ( 'FT-cal-acad-faculty only'[Faculty Rank] ) ),
0,
COUNT ( 'FT-cal-acad-faculty only'[Faculty Rank] )
)
Proud to be a Super User!
It didn't do anything, same as my option 1. it just again displays the same values without replacing any blank fields with '0' (i get the exact same table as in the picture above, with blank fields)
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
74 | |
71 | |
39 | |
27 | |
27 |
User | Count |
---|---|
97 | |
97 | |
58 | |
45 | |
42 |