How to make a column ignore slicer

[ClearRide]

This is my table: 

SalesTable

Person	Sales	Sales Missed	Missed Sale %
A	10	2	20%
B	20	1	5%
C	30	3	10%

The only measure in the table: Missed Sales % = Divide (sum(SalesTable[Sales]), sum(SalesTable[Sales missed])

I have a slicer and or button that changes the value of Sales and Sales Missed (let's say reduces Sales by 1), which in turn changes the value of Missed Sales %. Is there a way to keep Missed Sale % unchanged/static when I press that slicer/button?

[aj1973 · Accepted solution]

Hi @ClearRide 

Use this

Missed Sales % =
VAR _Div = Divide (sum(SalesTable[Sales]), sum(SalesTable[Sales missed])

RETURN
CALCULATE( _Div , ALLEXCEPT(SalesTable , SalesTable[Sales Missed], SalesTable[PersonSales] ))