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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Greg888
Helper I
Helper I

Is there a way to apply a selected value to each row in a column

I'm struggling with a problem which seems so simple to achieve but seems impossible in PBI.

I have a column with multiple rows with different values in them

 

Col1
1.01

1.03

1.04

1.05

In my report I have a slicer with values of

£100
£200
£300 etc.

I want to use the value in the slicer to create a value either in a measure or in a column, the problem is the value selected is on the report and can be different each time.

What I effectively want to do is

Measure = ValueSelected*([col1]-1)

So the measure on the page would be 
100 * (1.01-1)
100 * (1.02-1)

If the user select 200 the measure would be

200*(1.01-1)

200*(1.02-1) 

 

ETc., the 100 and 200 being the figures selected in the slicer the 1.01, 1.02 are the values of the rows in the column

Any ideas


 

1 ACCEPTED SOLUTION
lukiz84
Memorable Member
Memorable Member

First of all you can't use a column for this, because columns are calculated during refresh. Has to be a measure.

 

- The table with 100, 200 and so on must be disconnected (= no relationship).

- Get the current selected value from the disconnected table

- Apply it to your measure, for example:

 

YourFinalMeasure =
   VAR RowValue = SELECTEDVALUE(YourTable[Col1])
   VAR SelectedBase = SELECTEDVALUE(DisconnectedTable[Value])
   
   RETURN (RowValue-1) * SelectedBase
  

 

 

 

 

View solution in original post

3 REPLIES 3
Greg888
Helper I
Helper I

Wow that worked a treat. Thank you so much!

Greg888
Helper I
Helper I

It is a measure I'm trying to create, thank you for replying however I don't think this will work as I only have one SELECTED Value the other is a row in a column.

WIll let you know thanks again.

lukiz84
Memorable Member
Memorable Member

First of all you can't use a column for this, because columns are calculated during refresh. Has to be a measure.

 

- The table with 100, 200 and so on must be disconnected (= no relationship).

- Get the current selected value from the disconnected table

- Apply it to your measure, for example:

 

YourFinalMeasure =
   VAR RowValue = SELECTEDVALUE(YourTable[Col1])
   VAR SelectedBase = SELECTEDVALUE(DisconnectedTable[Value])
   
   RETURN (RowValue-1) * SelectedBase
  

 

 

 

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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