Forum Discussion

lhern_ndez's avatar
lhern_ndez
Icon for Helper I rankHelper I
7 years ago
Solved

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

Need Help

4 Replies

    • lhern_ndez's avatar
      lhern_ndez
      Icon for Helper I rankHelper I
      7 years ago

      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