Forum Discussion
create a (calculated)column based on a selection with a unique value
Hi, I have a column 'hours' that needs to be fild with a unique value .i.e. '18' for all records, regardless the other columns. So every record needs to be 18 And with a slicer i want to change th...
MNedix
Solution Sage
Solution SageHi,
You can try the following:
Step 1. Create a new Table and generate the desired series.
ex: Value Selector = GENERATESERIES(0,23,1) - this will generate a series from 0 to 23 with increments of 1
Step 2. Read the selected value with the below measure:
Selected_Value =SELECTEDVALUE('Value selector'[Value],18) - this will read the Step 1 value BUT if nothing is selected it will return 18
Step 3. Make the Value selector a Tile or Drop-down Slicer
Step 4. Add the new measure to any table you want see the 2 screenshots
PS: if it solved your problem please mark it as the solution, this may help others looking for the same thing