Forum Discussion
amandabus21
Helper V
Helper VAdding 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
Greg_Deckler
Community Champion
Community Championamandabus21 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]
amandabus21Helper V
Helper VRe-adding the filters worked, thank you so much! 🙂 Greg_Deckler