"dax "
2 TopicsParameter in Power BI report Builder
Hi All - I'm facing an issue where Report Builder connected to a Power BI Semantic Model is returning multiple rows. To resolve this, based on this thread I created DAX from Performance Visualiser. There is no mention of how to insert parameters in the above thread. But using this thread I could find how to do it. But when I follow it, I get the error saying the Parameter X is not defined. I've looked at below solutions, but nothing works Pass a Parameter to DAX Query Report Builder - Stack Overflow Chris Webb's BI Blog: Power BI Report Builder And RSCustomDaxFilter Re: The Query contains the "XXXX" parameter, which... - Microsoft Fabric Community Dynamic Parameters in PBI Report Builder using a p... - Microsoft Fabric Community Solved: Bug: Power BI Report Builder - Parameter Not Decla... - Microsoft Fabric Community All I need is, if I'm using the DAX provided by Performance Analyser in the report builder, what is the syntax for that query to use Parameters. Thanks2.1KViews0likes8CommentsHow to create drill-down matrix hierarchy with pre-aggregated data without double-counting?
I have a pre-aggregated dataset from an agency where each hierarchy level has its own row with pre-calculated values: Category Total = 158,244 Sub-category = 45,000 Brand = 11,804 SKU = 350 The dataset also contains multiple periods (Q1, Q2, Q3, Q4, YTD, MAT) and regions — each combination of Product x Period x Region has its own row. Leaf nodes (SKU level) sum up correctly to parent values. What is the best approach to enable drill-down hierarchy in Power BI matrix with this data structure, without double-counting?Solved4KViews0likes6Comments