The MDX Count function returns the number of tuples in a set (the cardinality of the set). This function counts all tuples of the set regardless of empty values.
Count ( set [, IncludeEmpty] )
The set for which a tuple count is needed.
Optional and default (empty values are counted even if this keyword is omitted).
with
member Calendar.SSSSSS as count(members(Calendar)) member Calendar.EEE as count(members(Calendar), EXCLUDEEMPTY)
member Calendar.III as count(members(Calendar), INCLUDEEMPTY)
select
{ ([measure].[sales amount]), ([measure].[cash back]) } on 0,
{ ([Calendar].[ALL].[2019]), ([Calendar].[ALL].[2020]), (Calendar.SSSSSS), (Calendar.EEE), (Calendar.III) } on 1
from [Online Store] ;
| sales amount | cash back | |
| 2019 | 0 | 0 |
| 2020 | 8648640 | 0 |
| SSSSSS | 52 | 52 |
| EEE | 35 | 0 |
| III | 52 | 52 |