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.
| Author |
Topic |
|
billsox
Yak Posting Veteran
74 Posts |
 Posted - 2008-11-15 : 09:23:13
|
| Hi -- MDX newbie here. I've got a cube in which I want to create a calculated member that takes an average of a fact. My problem is that the calculation needs to filter out any zeros from the fact before performing the average. I'm figuring that I'll need to use the Filter() function but I'm unclear as to the exact syntax of the MDX expression. Can anyone post the best way to do this calculation?Thanks in advance,Bill |
|
|
|
|
|
Excluding zeros from MDX average