Forum Discussion
Adding Values
amandabus21 Couple potential ways to do it, just add the filters you have in the other visuals to the final visual. If there are conflicts, you can do things like:
Measure = CALCULATE([Measure 1], [Vehicle] = "Bus") + CALCULATE([Measure 2], [Vehicle = "Car") + [Measure 3]
Re-adding the filters worked, thank you so much! 🙂 Greg_Deckler
amandabus21 Measure = [Measure 1] + [Measure 2] + [Measure 3] ? A Stacked Clustered Column Chart?
Hi Greg Greg_Deckler
Yes that would work, but the graphs are filtered and I would need to the filters need to be added in.
For example the First one has a filter where it only includes "Bus" . I need that filter to be in there when caculating the total.
amandabus21 Couple potential ways to do it, just add the filters you have in the other visuals to the final visual. If there are conflicts, you can do things like:
Measure = CALCULATE([Measure 1], [Vehicle] = "Bus") + CALCULATE([Measure 2], [Vehicle = "Car") + [Measure 3]
Re-adding the filters worked, thank you so much! 🙂 Greg_Deckler