Return the selection of slicer/fliter to use it for calculation/

[rbiswas]

Hi All,

Suppose i have a Column named as "country and another column "Sales value". For all the country, i have "Sales values" in Dollar.

I want that if i apply a filter for a specific country, it should shows the "Sales value" in terms of the local currency by applying appropriate exchange rate. 

But, when nothing is selected in the filter, the net "Sales Values" i.e in global level should be shown in "Dollar.

Right now the problem is I made a column "Sales Value Local Curr"=Sales Value*Exchange rate. When filter is applied, the output shows the net value as needed. But, if nothing is selected, then it simply summed up all the values, which is wrong since the values correspond to different currency for different country.

[Datatouille · Accepted solution]

Hi @rbiswas

Supposing your table is named 'Sales'

Try this measure:

[Total Sales] = IF( Hasonevalue('Sales'[Country]) , Sum('Sales'[SalesValues(Local)]) , Sum('Sales'[SalesValues(Dollar)]) ) 

[rbiswas]

Thanks for the solution, it works 

One more question, is it posssible to return the selection data from the filter, since initially we were planning to implement the same using the data selected in filter