Hi,
please I am using the exists function, but it seems its not filtering, as the query in sql works well, this i query I am using below
with
member
measures.lil
as
count(
Exists
(
{([Transaction].[RPC Count].&[1],[Transaction].[Account ID].[Account ID])}
,
{([Account].[PAYMENTSTATUS].&[0],[Account].[Account ID].[Account ID])}
))
select
measures.lil on 0
FROM
[Sax]