Forum Discussion

sbiedrzycki's avatar
sbiedrzycki
Frequent Visitor
3 years ago
Solved

Dual slicer stacked cumulative sum area plot

I want to preface this by pointing out that I am still a novice with Power BI, so please feel free to suggest any odd area where something could be improved.   I am struggling with understanding ho...
Need Help
  • sbiedrzycki's avatar
    sbiedrzycki
    3 years ago

    I solved the problem.  I just wanted to report back for future users' sake who rely on these kinds of posts as I do.

     

    The root cause is the misunderstanding of the limits of calculated columns.  The DAX expressions, despite giving the impression of a dynamic aggregation similar to measures, do not appear to support sub-group aggregation with the slicers as I thought.  Measures are required to evaluate in this way.

     

    Creating the following measure allowed implementing the dynamic sub-group aggregation with slicing as desired.

    sum_outs =
    CALCULATE(SUM('Facts'[Number Completed]),
    FILTER(ALL('Date'), 'Date'[Date] <= MAX('Date'[Date])))
     

     

sbiedrzycki's avatar
sbiedrzycki
Frequent Visitor
3 years ago

Anyone else with input on this?  I'm still searching for a solution or at least understanding if what I am trying to do is technically possible within Power BI.  I would appreciate if anyone could link me to any documentation or guides on understanding the fundamentals to how the data filtering layers are intended to work as I suspect a lot of my struggle is that I can't conceptualize how the DAX filter layers and other cross-visual filters are applying to the dataset prior to aggregation.