Dax compare agregates, possibly using self join

[Anonymous]

Hi all,

I am looking to compare the difference between outgoing and incoming values.  Folowing table is agregated:

    Origin           Destination       Sum of Quantity

    Location 1     Location 2        1234

    Location 2     Location 1         2345

    Location 1     Location 3         4566

    Location 3     Location 1         6432

One Idea I was a two kinds of calcuate that sumed of the quantity grouped by origin - the sum of the quantity grouped by desitnation. Where origin = destination.  The problem I see with this method is it might be rather limited in use.

Another idea would be to have the reader select the location.  Then out put the difference to a card.  that seems the simplest fix. But you wouldn't be able to map the difference.

Thoughts?

p.s. sorry if I take a while to respond. I wont be receiving email notifications.

[Anonymous · Accepted solution]

I have been able to get a work around for this, by making the bar graph with an R visual.

[Anonymous]

Any chance you could do a quick mock-up of what you would like to see?  I think i have an idea, but want to be sure before I start putting in too much time

[Anonymous]

I would like to be able to use the measure on a map, bar graph or line graph (with time on the x axis, with or without grouping in on location).

However, If I end up needing more then one measure so be it.

The minimun requirment would be a bar graph, with each bar being the difference/gain/loss (incoming - outgoing) for each location.