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 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