Adding Values

[amandabus21]

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.

[Greg_Deckler · Accepted solution]

@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]

[Greg_Deckler]

@amandabus21 Measure = [Measure 1] + [Measure 2] + [Measure 3] ? A Stacked Clustered Column Chart?

[amandabus21]

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.

[Greg_Deckler · Accepted solution]

@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]

[amandabus21 · Accepted solution]

Re-adding the filters worked, thank you so much! 🙂 @Greg_Deckler