Measure Count and include blanks

[stibra]

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

[Anonymous]

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

[Adeel_Yousaf]

Add calculated column and you get what you want.

Count Required for test = COUNT(Table1'[Required for Test])

[FarhanAhmed1984]

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

[stibra]

Hi,

This is how it looks for me:

[FarhanAhmed1984 · 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

[stibra]

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"

[FarhanAhmed1984]

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

[stibra]

Forgot picture