topic Re: Adding Values in DAX Commands and Tips

Adding Values

amandabus21 — Fri, 07 Oct 2022 17:39:46 GMT

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.

Re: Adding Values

Greg_Deckler — Fri, 07 Oct 2022 19:19:37 GMT

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

Re: Adding Values

amandabus21 — Fri, 07 Oct 2022 19:56:40 GMT

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.

Re: Adding Values

Greg_Deckler — Fri, 07 Oct 2022 20:18:57 GMT

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 Values

amandabus21 — Fri, 07 Oct 2022 22:32:40 GMT

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