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 f...
Need Help
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
7 years ago

lhern_ndez

 

Hi, try with this:

 

Measure=SELECTEDVALUE(YourColumn) - 1


Regards

 

Victor

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