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
Sean Super Contributor
Super Contributor

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?

Sean Super Contributor
Super Contributor

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" ) )
)
Baskar Super Contributor
Super Contributor

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?

Baskar Super Contributor
Super Contributor

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!

KHorseman Super Contributor
Super Contributor

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)


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!
Baskar Super Contributor
Super Contributor

Re: Showing 0 from a measure in a table visualisation

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 5 members 3,048 guests
Please welcome our newest community members: