Using Except to exclude (none) results

Questions & Answers
1

Hello,

I´ve created a calculated member to exclude the (none) results from a Dimension:

image

But I still see the (none) members in the rows:
image

What am I doing wrong?

Thanks!
Antonio

2

Hi @AntonBDR

Most likely the reason for this behavior is due to wrong order of member selection in report.
Try resetting previous selections in report dimension “Assets Vertragszuordnung” from the dimension menu “All heiarchy level members” and only then enable the “Assets mit Vertrag” member again in the report.
The syntax of your code looks correct.

Martins / eazyBI