Forum Discussion
Creating Running total chart using DAX
For the first picture, if i click on the filters, only the top two (straight) target lines moved but not the other running total lines. And upon research online, I read this would be successful if my relationship was bidirectional.
As for running total, I did not use quick measure. I created my own measures. Example:
RTYTD =
VAR MaxDate = MAX('Calendar Table'[Dates])
RETURN
CALCULATE(SUM('Table1'[Potential Cost Savings]), FILTER(ALLNOBLANKROW('Table1'), 'Table1'[Actual Date] <= MaxDate && 'Table1'[Actual Date] <> BLANK()))
I figured out most of the solution in the last few hours, where if i add allcrossfiltered bit to the measure, the lines are corrected to what it shouldve been line in the picture 1. But if i clear filters, the two target lines (green & blue) still show wonky like picture 2. The problem is I dont know how to add the cross-filter logic since they are not really measures, they are just static numbers being pulled from power query that I created with target amt.
you can make them measures with a fake aggregation like MIN() or MAX() or AVERAGE()