topic Re: Count blank informatons and no Blank informations in DAX Commands and Tips

Count blank informatons and no Blank informations

Anonymous — Wed, 12 Jan 2022 12:47:43 GMT

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!

Re: Count blank informatons and no Blank informations

smpa01 — Wed, 12 Jan 2022 13:05:03 GMT

Anonymous unpivot the data in PQ

Re: Count blank informatons and no Blank informations

ValtteriN — Wed, 12 Jan 2022 13:15:03 GMT

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!

Re: Count blank informatons and no Blank informations

Anonymous — Tue, 18 Jan 2022 12:18:46 GMT

ValtteriN

Thanks !!