Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
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
Wow that worked a treat. Thank you so much!
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.
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
User | Count |
---|---|
77 | |
75 | |
46 | |
31 | |
28 |
User | Count |
---|---|
99 | |
93 | |
50 | |
49 | |
46 |