Forum Discussion

lhern_ndez's avatar
lhern_ndez
Icon for Helper I rankHelper I
8 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
8 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
    8 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

     

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

      works great, thanks!