Forum Discussion
How to Subtract Two Locational Values from Eachother
Hello,
This question is similiar to another I have on the board, but I am trying to find different ways to display this data without wasting too much time. Based on another user's suggestion I combined two tables via UNION into one calculated tabled.
But when I did so, the two calculated columns I had created for each table combined into one column. Now I understood what the previous user had suggested, once the two columns were side by side on the same caculated table finding the difference would be easier.
Would anyone know why the two columns combined? And if that function is un-avoidable, how do I go from the screenshot below in finding the difference between each locaion per NAME.
AshlerK , One option is like
Compare two Brands: https://youtu.be/exN4nTewgbc
or
new measure =
var _max = maxx(allselected(Item),Item[Item])
var _min = minx(allselected(Item),Item[Item])
returncalculate([measure], filter(item , Item[Item] = _max)) - calculate([measure], filter(item , Item[Item] = _min))
1 Reply
- amitchandakSuper User
AshlerK , One option is like
Compare two Brands: https://youtu.be/exN4nTewgbc
or
new measure =
var _max = maxx(allselected(Item),Item[Item])
var _min = minx(allselected(Item),Item[Item])
returncalculate([measure], filter(item , Item[Item] = _max)) - calculate([measure], filter(item , Item[Item] = _min))