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?
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
.