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 |
|
isaacbs
Starting Member
10 Posts |
 Posted - 2008-01-17 : 20:21:45
|
| I have the following calculated member that searches all the plane pilots that have flight minutes during the monthDISTINCTCOUNT(FILTER(NONEMPTYCROSSJOIN({[Measures].[Minutes]}, DESCENDANTS([Role].[Role].CURRENTMEMBER)), NOT ISEMPTY((([Measures].[Minutes], [Type].[Type].&[1]) + ([Measures].[Minutes], [Type].[Type].&[2])))))But the total shows a weir total200701 0200702 0200703 0200704 0200705 0200706 0200707 0200708 0200709 02007010 3852007011 3832007012 383Grand Total 390The first few months have no info yet, but the last trimester has info, but no month gets to 390 pilotsAny idea why this can be happening and how could I filter the months with 0 pilots from the COUNT??Thanks in Advance |
|
|
|
|
|
problem with calculated member total