Forum Discussion

AshlerK's avatar
AshlerK
Regular Visitor
4 years ago
Solved

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])
    return

    calculate([measure], filter(item , Item[Item] = _max)) - calculate([measure], filter(item , Item[Item] = _min))

1 Reply

  • 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])
    return

    calculate([measure], filter(item , Item[Item] = _max)) - calculate([measure], filter(item , Item[Item] = _min))