Measure help

[Aysh_2104]

Sum value of measure with same slicer(repeated) and has edit interaction. 

[Greg_Deckler]

@Aysh_2104 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Aysh_2104]

Hello @Greg_Deckler 

Here is an example :-

You can see the edit interaction between the two rows, it has same slicer but works according to the edit interaction. I want the sum of these two numbers that works according to the slicer change.

[Greg_Deckler]

@Aysh_2104 Well, assuming Sum is a measure, maybe:

Measure = [Sum] + CALCULATE([Sum],ALLEXCEPT('Table'[Country]))

or:

Measure = [Sum] + CALCULATE([Sum],REMOVEFILTERS('Table'[Frequency]))

[Aysh_2104]

Both aren't giving me the output because of the edit interaction.

[Aysh_2104]

Both aren't giving me the output because of the edit interaction.

[Greg_Deckler]

@Aysh_2104 So are the slicers using the same column? If that is the case, perhaps have both slicers interact with the new visual and then do something like:

Measure = 
  VAR __Frequencies = 'Quantity'[Frequency chg]
RETURN
  CALCULATE([Sum],FILTER('Quantity',[Frequency chg] IN __Frequencies))

Not super positive that will work and you may need to use two different tables for your slicers instead. You could a table of frequencies using using DISTINCT.