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,
I'm using the following measure to calculate howmany applicants had an interview. This works and I'm using this measure in a table-visualisation. 0's are not showing in my table which I do want to see instead of a blank space.
Interviews = CALCULATE(COUNTROWS(FILTER('Applications';'Applications'[Status] = "Interviews")))
How can I make sure that rows (vacancies) which had no interviews take place show a 0 instead of nothing? I have tried some things I found on the forum but nothing worked out for me (or I mis-used them), such as adding +0 and using if isblank. It's also not possible to 'show items with no data' on a measure...
Hope someone can help me out! 🙂
Tom
Hi
Check your Measure or consdition with blank,
like
If (Isblank(Measure or Condition),"Blank Replace value", "What actually u want")
I hope it will help u
ISBLANK didn't work; it still just shows empty spaces. Also when I replace the 0 with 18 for example, it still doesnt show the 18 values. Could this be because its not actually blanks that's being returned but 0's, and these 0's are not showing up?
I have one more idea pls check it this
IF( ISNUMBER(Value),"Your Calculation",0")
Thanks a lot for your effort Baskar, but still no luck!
Can u please share your .pbix file , i will come with solution
How about
Measure = VAR ivct = CALCULATE(COUNTROWS(FILTER('Applications';'Applications'[Status] = "Interviews"))) RETURN IF(ivct = 0, 0, ivct)
Proud to be a Super User!
@TBenders So if ISBLANK is not helping
Try creating a Column = 0
Look at my response here...
http://community.powerbi.com/t5/Desktop/Force-table-to-show-blanks/m-p/38314#M14191
Thank you for your response!
A lot of the other columns in the table already have numbers in them. I have also added the 1-column but this has no effect on the empty spaces.
It could be that I mis-used the ISBLANK. Could you show me how my measure would look using ISBLANK?
@TBenders You don't really need the CALCULATE
This should work
Measure = IF ( ISBLANK ( COUNTROWS ( FILTER ( 'Applications'; 'Applications'[Status] = "Interviews" ) ) ); 0; COUNTROWS ( FILTER ( 'Applications'; 'Applications'[Status] = "Interviews" ) ) )
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |