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
Anonymous
Not applicable

How to compare null to values in the same column

Hi, I have a column that has numbers and some fields are blanks, I want to compare the total numbers to the number of blank fields.

I filtered it not to show the blanks, but now how do i display the blanks in the chart ?

3 REPLIES 3
FrankAT
Community Champion
Community Champion

Hi @Anonymous 

I don't know what you are facing:

    • If you want to calculate the number of values and the number of blanks you can do it like this
    • 15-09-_2020_23-10-13.png

 

  • May be you want to show items with no data:

15-09-_2020_23-15-20.png

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

Sumanth_23
Memorable Member
Memorable Member

hi @Anonymous  - you can add a calculated column to get the number of Blanks in the specified column

Please refer to the below screen grabs for reference

 

Sumanth_23_0-1600197264888.png

 

Sumanth_23_1-1600197342586.png

 

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

 

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

Proud to be a Super User!



PaulDBrown
Community Champion
Community Champion

@Anonymous 

Just add a 0 to your measure 

for example: sum of values = SUM(table[column]) + 0

you can then compare to values == 0





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






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.