Forum Discussion
Update values in table which are based on a measure
Yes. The scorecard value is supposed to be shown on the column chart in the way it is shown. A simple chart from the scorecards would look something like this.
This updates the value as scorecard value changes, but it is not something I want.
Hi sachal_rana,
You make me confuse. Your first issue about "column don't change when using slicer" already solve by yourself, aren't you?
- If yes, please update your own answer with the right fomular (using what-if,...) and choose solution. Then open a new issue for your next problem, and tag my nickname in new topic please.
- If no, please description more the result expect. I just found your need at this moments: "Basically I want to show the custom ranges on the x-axis and the value in the scorecard on the y-axis. The values are based on a custom measure which updates based on the slider value."
Regards,
ManNVSM.
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.
Hi sachal_rana,
Please try this:
- Copy "Value column" fomular, and delete this column.
- Create "New Measure", paste old formular in.
- 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.
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.
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])