OK I have a Category Count Measure in the cube that counts the amount of Employees for example: -
Employees Count in the cube displays as: -
Which is correct there are 15 employees but some of them work for more than one department.
Where as when reporting from the cube in Report Studio just adds up the figures, it seems you can;t do count distincts like you can when reporting straight from the framework.
Any ideas how to resolve this and get the total to be 15 in report studio.