Forum Discussion
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
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
8 Replies
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
Hi,
This is how it looks for me:
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
- Add calculated column and you get what you want.Count Required for test = COUNT(Table1'[Required for Test])
