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

Adeel_Yousaf's avatar
Adeel_Yousaf
Frequent Visitor
4 years ago

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