Measure to subtract 1 from selected value

[lhern_ndez]

Hello,

I have a very easy question but hard to me!

I have a slicer with a dropdown list where I can select only 1 value. Once I select the value, let's say 25,000, I want a measure to reduce 1 from that selected value in the slicer,

How can I do that?

With the following formula I am able to obtain the selected value for the slicer but not sure how to subtract 1, Thus I want the result of the measure to be 24,999

Measure = Allselected(TableColumn)

Thanks in advance!

Luis

[Vvelarde]

@lhern_ndez

Hi, try with this:

Measure=SELECTEDVALUE(YourColumn) - 1

Regards

Victor

[v-frfei-msft · Accepted solution]

Hi @lhern_ndez,

Try this one.

Measure = MAX(Table1[value])-1

Also please find the pbix attached.

Regards,

Frank

[lhern_ndez]

works great, thanks!

[lhern_ndez]

@Vvelarde

Thanks for your help, it shows me an error, I believe because the value I select is repeated which is normal, how can you modify the formula considering that the column contains duplicates of the value selected?

I do not need to add up the values or anything, simply subtract - 1 of the value selected regardless if it has doubles or not,

Thanks!

Luis