Calculate the Subtract values based on the slicer value you have chosen

[Anonymous]

Dear all 

I have two slicers, continent and countries y, 

in the countries table, we have countries and items and profit 

I want to be able to choose two countries and see the Absolute Subtraction value between all the items within the 2 countries that I chosed

As default, Power BI is showing the SUM.  

The value in the visual should represent the subtraction of different products in Germany and Sweden. 

Thanks in advance 

Regards 

[tamerj1]

@Anonymous 

What if you select 3 or more or even 1 what should be the expected result?

[Anonymous]

we could either limit the countries' slicer to choose only 2 ( I don't know how to do that 🙂 ) or continue subtracting from the final abstract result 

[tamerj1 · Accepted solution]

@Anonymous 
One way of doing that

=
VAR T1 =
    ADDCOLUMNS (
        VALUES ( 'Table'[Country] ),
        "@Value", CALCULATE ( SUM ( 'Table'[Value] ) )
    )
VAR MaxValue =
    MAXX ( T1, [@Value] )
VAR MinValue =
    MINX ( T1, [@Value] )
RETURN
    MaxValue - MinValue

[Anonymous]

It works great 

thanks a lot 🙂