allnoblankrow doesn't show expected value

[Anonymous]

What am I missing in the allnoblankrow function?

I have a data tabke that looks like this:

ID	date	Type
1	1/21/2022	a
2	1/17/2022	b
3	1/21/2022
4	3/6/2022	b
5	3/19/2022	a
6	3/29/2022	a

And I have a measure:

No Blanks Count = COUNTROWS(ALLNOBLANKROW(Data[Type]))

The measure returns 3, while I expect it to return 5 (all raws where type is not blank)

[Anonymous]

@amitchandak , thanks, I indeed  used filter instead and it works, however my question was meant to understand the ALLNOBLANKROW function, which if would work as expected is much more intuitive.

[Anonymous · Accepted solution]

Hi @Anonymous ,

I created a sample pbix file(see attachment) for you, ou can refer to the following link and the example in the pbix file to understand why you use the below formula to get 3 instead of a 5...

ALLNOBLANKROW

Assue that you have the below table data:

1. Create a calculated table

2. Create the measure [No Blanks Count]

ALLNOBLANKROW('Data'[Type])

ALLNOBLANKROW('Data')

Best Regards

[amitchandak]

@Anonymous , Try these

COUNTROWS(filter(Data, isblank(Data[Type])))

If the below one give data means some blanks are empty string not blank

COUNTROWS(filter(Data, Data[Type] =""))