Forum Discussion

stibra's avatar
stibra
Frequent Visitor
8 years ago
Solved

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.   ...
  • FarhanAhmed1984's avatar
    FarhanAhmed1984
    8 years ago

    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's avatar
stibra
Frequent Visitor
8 years ago

Hi,

 

This is how it looks for me:

FarhanAhmed1984's avatar
FarhanAhmed1984
Resolver III
8 years ago

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's avatar
    stibra
    Frequent Visitor
    8 years ago

    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"

     

     

    • stibra's avatar
      stibra
      Frequent Visitor
      8 years ago

      Forgot picture

       

    • FarhanAhmed1984's avatar
      FarhanAhmed1984
      Resolver III
      8 years ago

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