Help with DAX Query- RSCustomDaxFilter

Jayasreeb — Tue, 25 Oct 2022 17:06:36 GMT

Hi Everyone,

I need some help with DAX Query. I am using Paginatedreports for PowerBI reports export functionality.

In PowerBI, I am planning to pass 3 parameters(multi valued parameters) in a URL for a PaginatedReport export .

Here is the query I generated using Query designer in paginated report.

EVALUATE SUMMARIZECOLUMNS(
'DealerDim'[OrganizationCode],
'DealerDim'[OrganizationName],
'DealerDim'[City],
'DealerDim'[State],
'InventoryFact'[TotalParts],
'InventoryFact'[TotalSKUs],
'InventoryFact'[InventoryValue],
'PartsDim'[PartNumber],
'PartsDim'[PartDescription],

RSCustomDaxFilter(@City,EqualToCondition,[DealerDim].[City],String),
RSCustomDaxFilter(@OrganizationCode,EqualToCondition,[DealerDim].[OrganizationCode],String),
RSCustomDaxFilter(@PartNumber,EqualToCondition,[PartsDim].[PartNumber],String),
)

Problem-

When a user selects All for @PartNumber the URL length is too long and erroring out.

So I am planning to send "ALL" value to @@PartNumber parameter when the user chooses SelectALL

Requirement -

So whenver I pass ALL value to @PartNumber parameter, I want following piece of line to be ignored or not executed RSCustomDaxFilter(@PartNumber,EqualToCondition,[PartsDim].[PartNumber],String), I tried to use IF condition and OR function. But nothing seems to be working for me.

Also, I see few articles suggesting to not to use Query designer in PaginatedReport builder to generate DAX query. Any input on that?

Any help with this is greatly appreciated .

Re: Help with DAX Query- RSCustomDaxFilter

v-yueyunzh-msft — Wed, 26 Oct 2022 02:29:49 GMT

Hi , Jayasreeb

Based on my research and search, you can refer to this document for Query designer's query to specify limits to check if it helps:

Build a Query in the Relational Query Designer (Report Builder and SSRS - SQL Server Reporting Services (SSRS) | Microsoft Learn

Our team of engineers have also explained whether Query designer is not recommended or should be removed, you can check out this issue forum post:

https://community.powerbi.com/t5/Issues/Query-Designer-is-a-bug-and-should-be-removed-commented-out/idi-p/2326628

Best Regards,

Aniya Zhang

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

topic Re: Help with DAX Query- RSCustomDaxFilter in DAX Commands and Tips

Help with DAX Query- RSCustomDaxFilter

Re: Help with DAX Query- RSCustomDaxFilter