Add Value of a row to another row when 2nd filter is selected

[GR83]

Hi I have a Table 

Where I have location and days of a week with Values

Ex

Location    Mon   Tue   Wed   Thu  Fri   Sat  Sun

Atlanta         5        7        3        2     5     4      9

Dallas           5        3        3        4     3      1      5

I have to create 2 single select location slicers A & B

if I select Atlanta in Slicer A and Dallas in Slicer B

I want to add Atlanta Values to Dallas Values

[amitchandak]

@GR83 , In this case the first slcier need to a connected City table slicer and the second slicer need to on a disconnected city table slicer and you need a measure

M1= calculate(sum(Table[Value]) , keepfilters(Table, Table[City] in union(allselected(city[City]) , allselected(city2[City]) )

))

OR

M1= calculate(sum(Table[Value]) , filter(Table, Table[City] in union(allselected(city[City]) , allselected(city2[City]) )

))

Also check

Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc

[GR83]

Hi, Thanks for the reply, do I need to create Measure for each day of week seperately.