Forum Discussion
Issue with distinct Sum on Line and Column Stacked Chart
I have a Line and Column Stacked Chart (x-axis: Type, column y-axis: count, line y-axis: amount) with a slicer (date).
Count is calculated DISTINCTCOUNT(Query1[id])
Amount is a calculated CALCULATE(SUM(Query1[amount]),ALLEXCEPT(Query1,Query1[id], Query1[Type]))
Issue is the line axis (amount) does not change with slicer (date). It remains the total amount regardless of which period selected on slicer. Is my formula or missing some parameters?
Thank you
Is your [Date] is also in your Query table? This should be avoided if possible.
But in this case you could just add it you your ALLEXCEPT exceptions.
CALCULATE(SUM(Query1[amount]),ALLEXCEPT(Query1,Query1[id], Query1[Type],Query1[Date]))
2 Replies
PVO3Impactful Individual
Is your [Date] is also in your Query table? This should be avoided if possible.
But in this case you could just add it you your ALLEXCEPT exceptions.
CALCULATE(SUM(Query1[amount]),ALLEXCEPT(Query1,Query1[id], Query1[Type],Query1[Date]))