Forum Discussion
Solved
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...
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 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