My problem is that for my cumulative sales graph to work I have to show all dates on the graph. I’d like to only be able to show the last 8 qrts and show the cumulative sales of all time up until those qtrs.
In the pictures you can see total cumulative sales all time is over 7M, however if I filter the dates on the x-axis for the last 8 qtrs it shows cumulative sales around 2M. How do I get that cumulative sales to show 7M with only the last 8qtrs selected.
Is the Dax I’m using rn
CALCULATE( [Total Sales],
FILTER( ALLSELECTED( ‘fin FactTransactionActivity’ ),
‘fin FactTransactionActivity’[DimReportDateID] <= MAX( ‘fin FactTransactionActivity’[DimReportDateID] )