Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sachal_rana
Frequent Visitor

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 column chart does not update. 

What is a workaround of this? 

12 REPLIES 12
Anonymous
Not applicable

Hi @sachal_rana,

    Please check this:

  • Column: table only load 1 time when Opening or Load data.
  • Measure: refresh when interaction (Clicer, click to forcus visualization,...)

   You can using a "New measure" instead of "New column". Send me your sample pbix file, I can fix on it and resend 🙂

 

Regards,

ManNVSM.

RMDNA
Solution Sage
Solution Sage

@sachal_rana,

 

A measure changes in response to front-end changes to the table (by slicing, cross-filtering, etc.). How would you change the value of a measure directly?

The value of the measure is being changed indirectly through a what-if measure. The measure is currently based off of a count which changes based on another measure that is being calculated using a what-if measure. 

Hi @sachal_rana

 

Is it possible to share some sample data, measures and the outcome expected. Please put in google drive or one drive and share the link to explore solution.

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

I can share some screenshots over here. I cannot share the data itself. If this is not enough, let me know and I'll find a way to send you the stuff.

h1.png

Changing the slider value updates the encircled scorecards. The scorecards are shown in the table and the column chart is based off of the scorecards.


The formula for filling the table.

h2.PNG
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.
Anonymous
Not applicable

Hi @sachal_rana,

So, you want your Bar visualization, column "Value" will update the data same with Line 2 - Score card

Exp: 50-60% will change 1016 to 1091   ; 60-70% will change 841 to 1085 ; and go on.....until 90-100%? But it's seem nothing else matter?

 

Hope you can share me your pbix in private box with missing some important data.

 

Regards,

ManNVSM.

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. 
h3.PNG

Anonymous
Not applicable

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. 

Anonymous
Not applicable

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.

@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])

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.