Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Is it possible to ignore the selections on a dimension for GetPossibleCount() ?
GetPossibleCount() is not a aggregation function so simple Set Analysis is not valid. If it was valid I would use something like the below
GetPossibleCount ( { <[Dim1]=>} [Dim2] ) )
Any suggestion for something that is valid ?
Best Regards, Bill Markham
May be like:
Count ( { <[Dim1]=>} Distinct [Dim2] )
Many thanks, that works perfectly.