Forum Discussion

giordafrancis's avatar
giordafrancis
Frequent Visitor
5 years ago
Solved

Measure vs calculated columns for data quality

consider below frame

 

I want to be able to create a measure that displays te counts of blanks and non blanks to be used in a pie chart or pivot table .
I've managed to rcraete this easily with a calculated column but looking for best pratices on how to create this as a measure. 

animalis_blank
catNo
 Yes

dog

No

 

Thank you in advance

Data Protection
  • TomMartens's avatar
    TomMartens
    5 years ago

    Hey giordafrancis 

     

    you can create a measure that counts the non blanks like so:

    no of non-blank animals =
sumx(
'your table'
, if( not( isblank( 'your table'[animal] ) ), 1 )
)

    A second measure that counts the blanks can look like this.

    no of blank animals =
sumx(
'your table'
, if( isblank( 'your table'[animal] ) , 1 )
)

    Hopefully this provides what you are looking for.

     

    Regards,

    Tom

1 Reply

  • TomMartens's avatar
    TomMartens
    Super User
    5 years ago

    Hey giordafrancis 

     

    you can create a measure that counts the non blanks like so:

    no of non-blank animals =
sumx(
'your table'
, if( not( isblank( 'your table'[animal] ) ), 1 )
)

    A second measure that counts the blanks can look like this.

    no of blank animals =
sumx(
'your table'
, if( isblank( 'your table'[animal] ) , 1 )
)

    Hopefully this provides what you are looking for.

     

    Regards,

    Tom