We have also created an dimension of this table because we want to slice on it.
I am trying to create a calculated member so that I can show on the Y-axis the users and the X-axis the calculated member where [Assignments].[status id] = 3.
The [End User] dimension has a relation to the [Assignments] fact table through [Assignments].[user id] -> [End User].[id]. I want to slice on the End User and show the count of where [Assignments].[status id] = 3 as a calculated measure.
I have tried a number of ways, but basically, trying to interate through each member of the [Assignemnts].[User] and where statusid = 3 and sum
Microsoft führt eine Onlineumfrage durch, um Ihre Meinung zur Technet Website zu erfahren. Wenn Sie sich zur Teilnahme entscheiden, wird Ihnen die Onlineumfrage angezeigt, sobald Sie die Technet Website verlassen.