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 .
