Search code examples
sqlsql-server-2008-r2ssasmdx

How can I filter Fact with a Dimension?


I use SSAS and SQL Server 2008 R2

I write this query and it works:

SELECT 
 [Measures].[Circulation Count] 
    ON COLUMNS 
FROM [Store]
where [Circulation Kind].[Circulation Code].&[1]

And result is : 362154.2154

But when I use Filter function my result is empty.

SELECT 
Filter(
    [Measures].[Circulation Count] 
         ,
    [Circulation Kind].[Circulation Code]
    = 
    [Circulation Kind].[Circulation Code].&[1]
)
    ON COLUMNS 
FROM [Store]

How can I filter my result with the Filter function?


Solution

  • After communication with @FrankPI i fond that is good :

    With 
        Member X As 
           ( 
              [Measures].[Circulation Count] , 
              (
                  [Circulation Kind].[Circulation Code].&[1]
              ) 
           )
    
    Select 
        X On Columns
    From <>
    

    And in this method i can filter my measure with a dimension.