'How to write Cascading parameter using DAX in Report Builder

I have a Power BI dataset as a data source in Power BI Report Builder. I have use DAX expression to generate the parameter as shown below:

EVALUATE SUMMARIZECOLUMNS('DimensionList'[TopLevel], 'DimensionList'[SubLevel], 'DimensionList'[Dimension], RSCustomDaxFilter(@DimensionListTopLevel,EqualToCondition,[DimensionList].[TopLevel],String), RSCustomDaxFilter(@DimensionListSubLevel,EqualToCondition,[DimensionList].[SubLevel],String), RSCustomDaxFilter(@DimensionListDimension,EqualToCondition,[DimensionList].[Dimension],String))

However, this is not cascading parameter. How can I rewrite this to cascade from TopLevel to SubLevel and finally Dimension?

reporting-servicesdaxssrs-2012reportbuilder3.0powerbi-paginated-reports


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

Report wont run when using OLE DB connection

ORA 01797- operator must be followed by any or all

SSRS fixed position of tablix in body of the document. Visual Studio

A timeout (30000 milliseconds) was reached while waiting for a transaction response from the ReportServer service

SSRS - Disabling export options (eg. PDF) for individual reports

Tabbed Reports in SSRS

SQL server report error - "rsInternalError"

Strange issue in SSRS 2016. I am unable to select parameters or run the report intermittently, it works fine most of the time

SSRS Reporting in Blazor

Setting a list of several values to one SSRS parameter in "Available values"

SSRS Tablix border size inconsistent

The version of the report server database is either in a format that is not valid, or it cannot be read

Reporting Services - show multiple values for a column horizontally rather than vertically

SSRS Data Driven File share account - impersonation error

SSRS avoid WHERE clause if select all is selected