Help with DAX Query- RSCustomDaxFilter

[Jayasreeb]

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 .

[v-yueyunzh-msft]

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

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

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