Was looking to create a calculated Measure Which needs to be dependent on another column of the FACT table.
I need to have the Average of the particular Measure based on the fact that this particular 'set' has a common Related dimension's
The example would give a better picture.
I have a set of dimensions like
STUDENT, TEACHER, COURSE etc as my dimensions and the
grades, class standing based on marks for the subject, percentage of marks scored, Percentile, Marks Scored,StudentID and the related PK's etc are the measures on my fact table
Here I want the Avg of the marks scored by the Students based on the grade say is A or B or C
I was looking to create a calculated measure by using MDX
which was a follows
(NOT THE CORRECT SYNTAX JUST THE IDEA)
SUM (MARKS SCORED)/COUNT(DISTINCT StudentID)
WHERE GRADE = A
As this would be measured against a particular subject or a teacher or a Course.
I was hoping if I could get help in putting this in a proper SYNATAX
Thanks in advance.
View Complete Post