I am struggling with the Type Mismatch error when I query the cube in SSAS. The MDX query is shown below:
WITH
MEMBER [MEASURES].[TopNFilter] AS
IIF
(
Count((EXISTING Exists([DimClient].[Client].CurrentMember,TopNSet))) > 0,
1,
-1
)
SELECT
{
[MEASURES].[Volume],
[TopNFilter]
} ON COLUMNS,
{TopNSet} ON ROWS
FROM [Cube];
How can I fix this error