Help, formula is being filtered by slicer

[franorio]

Hi everybody, 

I got a really silly question, one of my report changed the scope, so i need to modify some calculation, so i need your help cracking this. 

This Report goes from July 2017 to June 2018. 

what it does is to measure from a certain initial basis of people on a budget, how many of them executed a new position on this time frame (july17-June18).

4A Total = VAR selectedTable = CALCULATETABLE ( 'Listado 4A - DELFI' ) RETURN CALCULATE ( COUNTROWS ( 'Listado 4A - DELFI' ), FILTER ( 'Listado 4A - DELFI', 'Listado 4A - DELFI'[Legajo sharp] ) ) + 0

I use the above formula to get the total number of persons who should be followed along the new year.

4A Ejecutados = CALCULATE ( COUNTROWS ( 'Listado 4A - DELFI'), FILTER ( 'Listado 4A - DELFI', 'Listado 4A - DELFI'[Adherencia OPR] = "OK" ) ) + 0

And this other formula to track who was "executed" .

When looking this on a matrix without selecteing a specific month (YTD). I see what i need to see as this:

total executed ytd, total to be executed, %, and how many are pending to be "executed".

But the problem is when selecting a specific month. For Example if i choose September..

The formulas bring me only executions of September allways as 100%, I should see executions of September over inital basis or Total persons to be executed, and not the 4A totals filtered... For the case of Supply, for september I should see 6 from 18.. no 6 of 6...  so 4A Total shouldn't be affected by my slicer of months

Appreciate your help!! Many tahnks!

Regards

[v-caliao-msft · Accepted solution]

@franorio,

Calculated measure value will re-calculate when selected a item on a slicer. In your scenario, you want that column to be a static value, you could create a calculated column instead. 

Reference
Calculated Columns and Measures in DAX

Regards,

Charlie Liao