Forum Discussion

cyclist007's avatar
cyclist007
Icon for Responsive Resident rankResponsive Resident
7 years ago

Using selected value of what if parameter in a Calculated column

I am trying to get a number input from the end user using the What if Paramater. I would then like to use that number in a calculated column and show the calculated column as a category on a colum...
Need Help
Show and Tell
Tips and Tricks
MonsieurLL's avatar
MonsieurLL
Regular Visitor
3 years ago

Similar issue here:

  1. I want the user to be able to select a date. I used a measure with SELECTEDVALUE to get this date.
    FXDate = SELECTEDVALUE(FX[Date])
  2. The date is associated with a number (FX rate). I created another measure with CALCULATE and FILTER to get the associated
    FXRate = CALCULATE(MAX(FX[USD/CAD]), FILTER(FX, FX[Date] = FX[FXDate]) )
  3. I have another table with numbers. I created a column in this table which multiplies each "Amount USD" by the FXRate measure.
    ValueTodayCAD = Transactions[Amount USD] * FX[FXRate]
  4.  When the user selects a different date, the measures all update correctly, but the new column does not recalculate using the new measure value for FXRate.

 

  • MonsieurLL's avatar
    MonsieurLL
    Regular Visitor
    3 years ago

    I found the answer: a calculated column will NOT update dynamically. Instead, we must use a measure.