Max of a slider as a column in my data

[Anonymous]

Hi,

Year	Month	Fac1	Amount
2020	1	0	118
2020	1	1	166
2020	2	5	367
2020	3	9	282
2020	3	2	214
2020	5	3	296
2020	7	4	414

I have created a slicer on 'Fac1' in above table. I want to print the max of slider as a column in the above dataset. 

Example:

if my slider is set from values 0 to 3... then my new data should appear like below:

Year	Month	Fac1	Amount	Max_Fac1
2020	1	0	118	3
2020	1	1	166	3
2020	2	5	367	3
2020	3	9	282	3
2020	3	2	214	3
2020	5	3	296	3
2020	7	4	414	3

Many Thanks

[v-xulin-mstf]

Hi, @Anonymous 

You can use the following method to meet your needs:

Step1: Create a slicer table as:

slicer Table =

VALUES(Table1[Fac1])

Step2: Create a measure as:

Max_Fac1 =

var _table=CALCULATETABLE(VALUES('slicer Table'[Fac1]),ALLSELECTED('slicer Table'))

var _maxvalue=MAXX(_table,'slicer Table'[Fac1])

Return

_maxvalue

Step3: Drag the measure into the table.

Here is the demo, please try it: Max of a slider as a column in my data.pbix

Best Regards,

Link Chen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi, 

Thanks for the solution. 

This is almost what i needed. Now i just want to convert this visualization table into a data table which will be a dynamic table. Is there a way?

[Anonymous]

Hi, 

My expected table is same as the visualixation created by you. But now i just want to convert this table into a new dataset (so i can use this table to create new measures) and this new table should be dynamic based on the slicer selection 

Basically, what you have done below in a visualization table i want it as a dataset table 

[v-xulin-mstf]

Hi,@Anonymous 

I see, but it is not supported now.

Best Regards,

Link Chen

[v-xulin-mstf]

Hi,@Anonymous 

What does "a dynamic table" mean?

Sample data and expected output would help tremendously.

Best Regards,

Link Chen

[amitchandak]

@Anonymous , This will give max value in a column. But will not change base on slicer

new column = Max(table[Fac1])

[Anonymous]

My requirement is that it should change bases slicer

[amitchandak]

@Anonymous , Not possible. You can use that meausre by forcing some row context.

Assume you have unique ID column

Measure =maxx(allselected(Table), table[Fac1])

like

Measure 1 = Sumx(Values(Table[ID]), [Measure] * Max(Table[Value1]))

[Anonymous]

Not sure about row context? Does it helps to print a measure as a column?

is there no way we can print a measure into a column? or if we can create another table using that measure and join it back to original table ?

[amitchandak]

@Anonymous , You can not pass slicer value to a column. You have to use a measure

[Anonymous]

Thanks amit. Yes, agree. But my question is, can we print this measure value in all rows as a new column?

like if the measure output is "3" so now i want to have a new column in my data with all rows equal to "3"

[amitchandak]

@Anonymous , Try a measure like

maxx(allselected(Table), table[Fac1])

[Anonymous]

This works for a measure, but not when creating a new column. Is there a way that I can paste the measure value as a new column in front of all the rows of my data? As I have done in my initial question

[Anonymous]

This works for a measure but not when creating a new column. Is there any way i can paste the measure value as a new column in front of all rows in my data? Like i have done in my initial question