cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Jayasreeb
Frequent Visitor

Help with DAX Query- RSCustomDaxFilter

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 .

1 REPLY 1
v-yueyunzh-msft
Community Support
Community Support

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

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors