Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
TBenders
Helper II
Helper II

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! 🙂

 

Tom

 

 

9 REPLIES 9
Baskar
Resident Rockstar
Resident Rockstar

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)





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Sean
Community Champion
Community Champion

@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?

Sean
Community Champion
Community Champion

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.