Calculated Member to count fact table

Hi,

I'm having problems creating a calculated member to count specific rows of my fact table.

I need the number of rows matching a filter criteria. I tried it with using the filter expression but without any success.

Lets assume the following:

ID ColumnX ColumnY

1 A ABC1

2 B ABC2

3 A DEF1

DimensionX is based on ColumnX

DimensionY is based on ColumnY

Totals is a measure with a row binding lets say count(ID)

TotalsNoBinding is a measure with row binding and NO aggregation (None)

I would assume that a Calculated measure based on

Count(Filter([Measures].[TotalsNoBinding], [DimensionX].[A ]))

would result the count of "rows" affected by filtering the DimensionX by just allowing the Value A.

I guess I have a understanding problem somewhere. I hope someone can give the right hint to fix the problem. What would be the right way to implement this?

Thanks.

ErtanO

Try to use named calculation in datasource view in spite of create calculated member...

regards!

|||

PedroCGD

Thank you...that was the right hint!