cancel
Showing results for
Search instead for
Did you mean:
Helper I

## Measure to subtract 1 from selected value

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

1 ACCEPTED SOLUTION
Community Support

Hi @lhern_ndez,

Try this one.

`Measure = MAX(Table1[value])-1`

Also please find the pbix attached.

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
4 REPLIES 4
Community Champion

@lhern_ndez

Hi, try with this:

Measure=SELECTEDVALUE(YourColumn) - 1

Regards

Victor

Lima - Peru
Community Support

Hi @lhern_ndez,

Try this one.

`Measure = MAX(Table1[value])-1`

Also please find the pbix attached.

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Helper I

works great, thanks!

Helper I

@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

## Helpful resources

Announcements

#### Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

#### Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

#### What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

#### Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors