Forum Discussion
How to write Cascading parameter using DAX in Power BI 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?
1 Reply
Hi Anonymous ,
Please refer to the ducument to see if it helps you.
SQL Server Reporting Services Report Builder with DAX Query Support
How to create cascading parameters in paginated reports using Power BI Datasets - Power BI
If I have misunderstood your meaning, please provide more details.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.