When we write the subtotal measure, we look to a variable called Flag to define each unique subtotal row in the dimAccounts table. ![]() The main driver for cascading subtotals is the use of a flag column in the account dimension table. ![]() To learn more about the impact in Power BI, and the simple fix, check out this new video from our friends at SQLBI. Basically, the Power BI version of the query includes the ‘sort by column’ in the underlying query, where the same query in Power Pivot does not. The need to modify this for the sort order stems from a difference in the underlying query in Power BI vs. I also combine multiple expressions into one measure with the help of DAX variables. I’ve modified it slightly to work with sorted dimension columns in Power BI (defined above). The first subtotal method is cascading subtotals, and goes way back to a 2011 Power Pivot Pro post by David Churchward here.
0 Comments
Leave a Reply. |