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

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])))