topic Re: allnoblankrow doesn't show expected value in DAX Commands and Tips

allnoblankrow doesn't show expected value

Anonymous — Tue, 05 Apr 2022 10:55:22 GMT

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)

Re: allnoblankrow doesn't show expected value

amitchandak — Tue, 05 Apr 2022 11:33:23 GMT

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] =""))

Re: allnoblankrow doesn't show expected value

Anonymous — Tue, 05 Apr 2022 11:40:11 GMT

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.

Re: allnoblankrow doesn't show expected value

Anonymous — Fri, 08 Apr 2022 08:28:30 GMT

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]

Best Regards