Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  Stumped on Calculated Measure

Author  Topic  tbadbeer Starting Member 1 Post Posted - 2004-08-08 : 04:44:58 Haven't found the answer to this one in any of MS documentation or any Analysis Services books...got me stumped. One of my dimensions (disposition) has only four members (2,4,5,10). My first column, Total Calls, includes all 4 dispositions. My desired second column, Abandon Calls, would be just Disposition 2. How do I create a measure (or Calc Measure) that, even though the Disposition dimension is set to All, this will only show the count of records with disposition 2? Thx I am Stumped