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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
stibra
Frequent Visitor

Measure Count and include blanks

Hi,

 

I would like to create a simple measure from table 1, Column 2 where the result should be a count of Green, Blue and Blanks. When working with visuals it does not include the blank cells.

 

Table 1

 

Column 1   Column 2

Case 1        Green

Case 2        Blue

Case 3

Case 4        Green

Case 5        Blue

Case 6

Case 7        Green

Case 8        Blue

 

Result:

Green = 3

Blue = 3

Blank = 2

 

Any idea how I could display the blanks in the visual part? (Either by counting blanks or adding zeros)

 

Br

Stian

 

1 ACCEPTED SOLUTION

Ok understand it....

 

-Goto Edit Queries From Home Tab

-Select Column which has NULL Values

-Click on Replace Values

-Replace 'null' values with nothing

-Click 'OK'

-Close & Apply

 

Now you will see blank values in Donut Chart

BlankValues.png.jpgBlankValues2.jpg

View solution in original post

8 REPLIES 8
124578dtt4trt4
Regular Visitor

what DAX can we equate this to?  - for those who want to know?

Adeel_Yousaf
Frequent Visitor

image.png

Add calculated column and you get what you want.
 
Count Required for test = COUNT(Table1'[Required for Test])
FarhanAhmed1984
Resolver III
Resolver III

What Visual you are working on  ???

 

You can see blank Values with counts unless you have Page /Report/Visual Level filter applied on it for blank values

 

BlankValues.png

Hi,

 

This is how it looks for me:

2017-12-11_1748.png

Ok understand it....

 

-Goto Edit Queries From Home Tab

-Select Column which has NULL Values

-Click on Replace Values

-Replace 'null' values with nothing

-Click 'OK'

-Close & Apply

 

Now you will see blank values in Donut Chart

BlankValues.png.jpgBlankValues2.jpg

Hi and thanks for the assistance.

 

This worked fine when I use excel as data source, but my real data uses direct queries from an sql database / view. That's probably why I need to figure out how to create a meaure that prints 0 instead of "null"

 

 

Then you should use ISNULL/COALESCE in SQL queries to handle Null Values.

stibra
Frequent Visitor

Forgot picture

 

2017-12-11_1827.png

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.