My Fact Table has columns as
IssueId StatusId DateId Points
1 1 20130101 10
1 2 20130102 10
1 3 20130104 10
2 1 20130101 22
3 1 20130102 5
3 2 20130103 5
I wanted to see how many total points I have, it shows me 62 instead of 37.
Can any one tell me how do I fix this.
I heard there is a concept called Semi-Additive and Non-Additive Measures but I don't find any information on how to do it in SSAS. If you can provide that either, I will be greatful.
Thanks in Advance.
Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.