I was suprised to find the combination "..ISBLANK(Countrows(filter(...." in a measure, as I assumed controws() would return 0 if there are no rows, so this would always make isblank return True.
I looked it up in the MSDN function reference for Dax, and there it is stated that:
Whenever there are no rows to aggregate, the function returns a blank.
This I had figured out myself, however I do not understand the next bit.
However, if there are rows, but none of them meet the specified criteria, the function returns 0.
What are "specified criteria"? I tried different combination of calculate and filter and countrows, but it always returns a blank value in the pivottable.
P.S. Similar sentences appear in the Reference articles of other Count-functions, but I still do not see what it is supposed to mean.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?