Forum Discussion

marie_joy's avatar
marie_joy
Frequent Visitor
2 years ago

DAX: Achieve Running Total with Multi-Level Breakdown and Overall Totals

Hi,  I'm looking to create a DAX formula in Power BI that calculates a running total but also provides breakdowns and overall sums at different levels. Here's the scenario: I have tables named mon...
marie_joy's avatar
marie_joy
Frequent Visitor
2 years ago

I found a solution but I do not understand it. If I remove

        FILTER(
            ALLSELECTED(net_marg_product_lines),
            net_marg_product_lines[fiscal_year] = _CurrentFiscalYear

 from the DAX formula, I do have correct calculations...

 

If anyone can explain why, I will greatly appreciate!