Count blank informatons and no Blank informations

[Anonymous]

Hello, friends

I need your help, i need a measure that count blank values and no blank values in a data range, for example:

Blank is red and no blank is green, i need to count blank = 9 and no Blank = 1. Have a measure in DAX that help me with this?

Thanks a lot!

[ValtteriN · Accepted solution]

Hi,

Here is one way to do this:

DAX:

CountBlank = CALCULATE(COUNTROWS(NullToZero),ISBLANK(NullToZero[Data]))

CountNotBlank = CALCULATE(COUNTROWS(NullToZero),NullToZero[Data]<>BLANK())

The basic idea is the one shown in my example. To make it work in your context you might need to add ALL to filters and maybe use variables.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

[Anonymous]

@ValtteriN 

Thanks !!

[smpa01]

@Anonymous unpivot the data in PQ