How to get count of records in my fact table with MDX.

• a4apple

  SSCrazy

  Points: 2620

  More actions

  June 6, 2013 at 9:57 am

  #294913

  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.