Forum Discussion

sachal_rana's avatar
sachal_rana
Frequent Visitor
8 years ago

Update values in table which are based on a measure

My table contains two columns; one is static text field, and the other column has values based on a calculated measure. If the value of the measure changes, the table does not update and hence the co...
sachal_rana's avatar
sachal_rana
Frequent Visitor
8 years ago

Anonymous

Sir, I think you're not getting my problem. I know that there is a limitation of PowerBI currently that calculated columns are not updated when the values of the measures change based on the slicer. 

What I want to achieve is that I want this graph to update based on the scorecard values which change based on the slicer. How can I achieve that; that is the question. 

Check out the video. This might clear it up for you. 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi sachal_rana,

   Please try this:

  1. Copy "Value column" fomular, and delete this column.
  2. Create "New Measure", paste old formular in.
  3. Use new measure for your bar chart, ,try again.

By the way, please show me the fomular of each Measure1, I wonder what happen when selected age inside it. Maybe we'll using SELECTEDVALUE.

 

Regards,

ManNVSM.

  • sachal_rana's avatar
    sachal_rana
    Frequent Visitor
    8 years ago

    Anonymous

     

    I can't use the formula as a measure since it's referring to the TrainingZone column which is not allowed inside a measure. 

     

    Formula for  CountZone1 = CALCULATE(COUNT(tbl_Ronzio_HR[HR]),FILTER(tbl_Ronzio_HR,tbl_Ronzio_HR[HR]>=[Zone1_50%] && tbl_Ronzio_HR[HR] <= [Zone1_59%]))

     

    Formula for Zone1_59% = ROUND((([MaximumHeartRate] - [AverageRHR])*0.59) + [AverageRHR],0)

     

    Formula for MaximumHeartRate = 220 - Age where Age is being selected from Slicer.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,

     

    Did you ever get a solution to this? I'm also stuck here.

     

    Description:

    Data_Filter [cost] = Cost field
    Cost_Table [Month_Diff] = count of months it should get multiplied by
    Cost2Table [Incr_Rate] = Measure which is being controlled by a slicer


    Working:
    cost = (Data_Filter[cost])*(1.025^Cost_Table[Month_Diff])

    Not Working:
    cost = (Data_Filter[cost])*(Cost2Table[Incr_Rate]^Cost_Table[Month_Diff])