Help

[sravantig]

Working on DMR model

Inserting the below data items in my chart from my cube

X-axis- [1990], [1991], [1992]
Measure – [Turnover rate]
Series- [Centers]

My centers is a hierarchy something like this

Centers
    à Region
              à Districts

Now I need to show Number of centers having turnover rate less than 25%

I tried using Total([Centers]) by replacing the original series [Centres] in chart but I get this error:
"The dimensions on the edge are inconsistent. The dimension of valueSet="68" is not found on the first path"
I tried interchanging the position of data items in chart by placing both [Turnover rate] and Total([Centers]) in series, but I'm getting the same error

PLEASE HELP ME.. I'M STUCK HERE FROM PAST 2 WEEKS

**Let me know if you need in any further information.
--Thanks in advance.

[rockytopmark]

Just thinking out loud here...

What about replacing measure with new data item that returns your count of Centers that have Turnover <25%?

count(distinct filter([Centers],[Turnover rate] < .25) for [year])

[sravantig]

TY Rocky tried your expression, I got the below error

The selected aggregation type is not supported fo cross-tabs or for OLAP data sources: dataitem="Data Item1"; expression="count(distinct..)")


As far as my little knowledge... we cannot use count function on dimesional models... we need to use total function I guess

[sravantig]

anyone who can reply here please?