Paginated reports / Filtering using RSCustomDaxFilter not working

[Patv]

Hi Friends, 

I have a requirement to create a Paginated report and I am using DAX query ( generated by from using Performance Analyser) but I am not able to make it work. I have created a Dataset using below DAX query and then I added a line ( manually) RSCustomDaxFilter(@PROJECTPROJECTMANAGER,EqualToCondition,[PROJECT].[PROJECTMANAGER],String),  to DAX query to so it creates a Parameter and I can filter a data based on value I select for ProjectManager.    When I select all vaues from Parameter1 ( attached screen) I get all rows. But when I select PM4, PM5, PM6, PM7, PM8 then I want these rows to be disappear but only Measure ( calcucaled) values disappear  ( see scheen shot below). Could anyone please help me on this? I spend almost 2-3 days researching online and reading forum but can't able to get it work. Please please please help!. Thank you so much in advance!

// DAX Query
DEFINE
VAR __DS0Core =
SUMMARIZECOLUMNS(
'PROJECT'[PROJECTID],
'PROJECT'[NAME],
'PROJECT'[PROJECTMANAGER],
'MILESTONE'[MSDATE],
RSCustomDaxFilter(@PROJECTPROJECTMANAGER,EqualToCondition,[PROJECT].[PROJECTMANAGER],String),
"v2020_Cash_Allo", 'FINANCE'[2020_Cash_Allo],
"v2020_Capital_Allo", 'FINANCE'[2020_Capital_Allo],
"v2021_Cash_Allo", 'FINANCE'[2021_Cash_Allo],
"v2021_Capital_Allo", 'FINANCE'[2021_Capital_Allo],
"v2022_Cash_Allo", 'FINANCE'[2022_Cash_Allo],
"v2022_Capital_Allo", 'FINANCE'[2022_Capital_Allo]
)

VAR __DS0PrimaryShowAllCompat =
FILTER(
KEEPFILTERS(
GENERATEALL(
KEEPFILTERS(
FILTER(
KEEPFILTERS(VALUES('PROJECT'[PROJECTID])),
OR(
CALCULATE(NOT(ISEMPTY('PROJECT'))),
NOT(
ISEMPTY(
GENERATE(
KEEPFILTERS(
GENERATE(
KEEPFILTERS(VALUES('PROJECT'[NAME])),
VALUES('PROJECT'[PROJECTMANAGER])
)
),
FILTER(
KEEPFILTERS(VALUES('MILESTONE'[MSDATE])),
OR(
OR(
OR(
OR(
OR(
NOT(ISBLANK('FINANCE'[2020_Cash_Allo])),
NOT(ISBLANK('FINANCE'[2020_Capital_Allo]))
),
NOT(ISBLANK('FINANCE'[2021_Cash_Allo]))
),
NOT(ISBLANK('FINANCE'[2021_Capital_Allo]))
),
NOT(ISBLANK('FINANCE'[2022_Cash_Allo]))
),
NOT(ISBLANK('FINANCE'[2022_Capital_Allo]))
)
)
)
)
)
)
)
),
GENERATEALL(
KEEPFILTERS(
FILTER(
KEEPFILTERS(VALUES('PROJECT'[NAME])),
OR(
CALCULATE(NOT(ISEMPTY('PROJECT'))),
NOT(
ISEMPTY(
GENERATE(
KEEPFILTERS(VALUES('PROJECT'[PROJECTMANAGER])),
FILTER(
KEEPFILTERS(VALUES('MILESTONE'[MSDATE])),
OR(
OR(
OR(
OR(
OR(
NOT(ISBLANK('FINANCE'[2020_Cash_Allo])),
NOT(ISBLANK('FINANCE'[2020_Capital_Allo]))
),
NOT(ISBLANK('FINANCE'[2021_Cash_Allo]))
),
NOT(ISBLANK('FINANCE'[2021_Capital_Allo]))
),
NOT(ISBLANK('FINANCE'[2022_Cash_Allo]))
),
NOT(ISBLANK('FINANCE'[2022_Capital_Allo]))
)
)
)
)
)
)
)
),
GENERATEALL(
KEEPFILTERS(
FILTER(
KEEPFILTERS(VALUES('PROJECT'[PROJECTMANAGER])),
OR(
CALCULATE(NOT(ISEMPTY('PROJECT'))),
NOT(
ISEMPTY(
FILTER(
KEEPFILTERS(VALUES('MILESTONE'[MSDATE])),
OR(
OR(
OR(
OR(
OR(
NOT(ISBLANK('FINANCE'[2020_Cash_Allo])),
NOT(ISBLANK('FINANCE'[2020_Capital_Allo]))
),
NOT(ISBLANK('FINANCE'[2021_Cash_Allo]))
),
NOT(ISBLANK('FINANCE'[2021_Capital_Allo]))
),
NOT(ISBLANK('FINANCE'[2022_Cash_Allo]))
),
NOT(ISBLANK('FINANCE'[2022_Capital_Allo]))
)
)
)
)
)
)
),
FILTER(
KEEPFILTERS(VALUES('MILESTONE'[MSDATE])),
OR(
OR(
OR(
OR(
OR(
OR(
CALCULATE(NOT(ISEMPTY('MILESTONE'))),
NOT(ISBLANK('FINANCE'[2020_Cash_Allo]))
),
NOT(ISBLANK('FINANCE'[2020_Capital_Allo]))
),
NOT(ISBLANK('FINANCE'[2021_Cash_Allo]))
),
NOT(ISBLANK('FINANCE'[2021_Capital_Allo]))
),
NOT(ISBLANK('FINANCE'[2022_Cash_Allo]))
),
NOT(ISBLANK('FINANCE'[2022_Capital_Allo]))
)
)
)
)
)
),
OR(
OR(
OR(
OR(
OR(
OR(
OR(
OR(
OR(
NOT(ISBLANK('PROJECT'[PROJECTID])),
NOT(ISBLANK('PROJECT'[NAME]))
),
NOT(ISBLANK('PROJECT'[PROJECTMANAGER]))
),
NOT(ISBLANK('MILESTONE'[MSDATE]))
),
NOT(ISBLANK('FINANCE'[2020_Cash_Allo]))
),
NOT(ISBLANK('FINANCE'[2020_Capital_Allo]))
),
NOT(ISBLANK('FINANCE'[2021_Cash_Allo]))
),
NOT(ISBLANK('FINANCE'[2021_Capital_Allo]))
),
NOT(ISBLANK('FINANCE'[2022_Cash_Allo]))
),
NOT(ISBLANK('FINANCE'[2022_Capital_Allo]))
)
)

VAR __DS0PrimaryReordered =
SELECTCOLUMNS(
KEEPFILTERS(__DS0Core),
"'PROJECT'[PROJECTID]", 'PROJECT'[PROJECTID],
"'PROJECT'[NAME]", 'PROJECT'[NAME],
"'PROJECT'[PROJECTMANAGER]", 'PROJECT'[PROJECTMANAGER],
"'MILESTONE'[MSDATE]", 'MILESTONE'[MSDATE]
)

VAR __DS0PrimaryShowAll =
NATURALLEFTOUTERJOIN(
SUMMARIZE(
UNION(__DS0PrimaryReordered, __DS0PrimaryShowAllCompat),
'PROJECT'[PROJECTID],
'PROJECT'[NAME],
'PROJECT'[PROJECTMANAGER],
'MILESTONE'[MSDATE]
),
__DS0Core
)

VAR __DS0PrimaryWindowed =
TOPN(
501,
__DS0PrimaryShowAll,
'PROJECT'[PROJECTID],
1,
'PROJECT'[NAME],
1,
'PROJECT'[PROJECTMANAGER],
1,
'MILESTONE'[MSDATE],
1
)

EVALUATE
__DS0PrimaryWindowed

ORDER BY
'PROJECT'[PROJECTID], 'PROJECT'[NAME], 'PROJECT'[PROJECTMANAGER], 'MILESTONE'[MSDATE]

[v-janeyg-msft]

Hi, @Patv 

If you want to use dax filter, you may not be able to use RSCustomDaxFilter directly.

Check this:

RSCustomDaxFilter - Paginated Report - Microsoft Power BI Community

If you want to add multiple parameters in paginated report, You can check this method:

Solved: Add parameter in query designer (query from Power ... - Microsoft Power BI Community

Add a multi-value parameter to a paginated report - Microsoft Report Builder & Power BI Report Build...

Working With Multi-Select Parameters for SSRS Reports (mssqltips.com)

Hope it helps.

Best Regards,

Community Support Team _Janey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.