Hallo everyone,
My first query looks like this -Customer-:
set(member([Customer]))
My second query looks like this -Dates-:
total(currentMeasure within set [Dates])
My problem is in my third query:
topCount ([Customer];10;[Dates])
The error occures:
invalid coercion from 'level' to 'value' for '[__ns_0].[Customer_dim][Customer_dim].[level1]' in 'set(member([__ns_0].[Customer_dim].[Customer_dim].[level1]))'
Can anybody help me, what have I dont wrong?
Thank you..
Regards,
Ratna
try this:
topCount (set(member([Customer]));10;[Dates])
thank you khayman..