cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
TBenders Regular Visitor
Regular Visitor

Showing 0 from a measure in a table visualisation

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! Smiley Happy

 

Tom

 

 

9 REPLIES 9
Super User
Super User

Re: Showing 0 from a measure in a table visualisation

@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

TBenders Regular Visitor
Regular Visitor

Re: Showing 0 from a measure in a table visualisation

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?

Super User
Super User

Re: Showing 0 from a measure in a table visualisation

@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" ) )
)
Super User
Super User

Re: Showing 0 from a measure in a table visualisation

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

TBenders Regular Visitor
Regular Visitor

Re: Showing 0 from a measure in a table visualisation

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?

Super User
Super User

Re: Showing 0 from a measure in a table visualisation

I have one more idea pls check it this

 

IF( ISNUMBER(Value),"Your Calculation",0")

TBenders Regular Visitor
Regular Visitor

Re: Showing 0 from a measure in a table visualisation

Thanks a lot for your effort Baskar, but still no luck!

Super User
Super User

Re: Showing 0 from a measure in a table visualisation

How about

 

Measure = VAR ivct = CALCULATE(COUNTROWS(FILTER('Applications';'Applications'[Status] = "Interviews"))) RETURN IF(ivct = 0, 0, ivct)

Super User
Super User

Re: Showing 0 from a measure in a table visualisation

Can u please share your .pbix file , i will come with solution