Forum Discussion
Adding Values
Hello,
I have 3 visuals I created on a report, they use different measures and filters for each.
Is there a way I can get add them up to get a grand total?
For example: Sum from all 3 of these charts.
ex) All added up into one ending bar chart for a grand 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
4 Replies
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]