Forum Discussion
Dax compare agregates, possibly using self join
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.
3 Replies
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.