Assign value based on slicer Range selection

[Anonymous]

HI Team,

We came across one requirement in which we need one column(Can be custom Column) for which value should be populated based on slicer range selection(Dynamically).

eg: 

			Dynamic Value/Custom column
ID	Range	Value	Flag
1001	1	24	N
1002	2	12	N
1003	3	45	N
1004	4	34	Y
1005	5	23	Y
1006	6	48	Y

Now Range is slicer from where based on range selection Flag column should assign Y or N dynamically.  if range is falling between selection then Y else N. 

Slicer range selected from 4 to 6 hence Flag column populated value as Y for the same. 

We have tried with ISfiltered DAX function but the problem is , it is not working if we are creating this as custom column . 

Thanks

[Fowmy · Accepted solution]

@Anonymous 

You need to create a measure, Columns will not work as they are not affected by the slicer filters.

=IF ( MAX(TABLE[RANGE] >= MIN(SLICER[COLUMN] && MAX(TABLE[RANGE] <= MAX(SLICER[COLUMN], "Y", "N") 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

HI @Fowmy 

Thanks for your response on the query. 

We would like to know if we want to achieve interection with other visuals then This measure is not interacting. 

Is there any way to achieve interaction? 

			Dynamic Value/Custom column
ID	Range	Value	Flag
1001	1	24	N
1002	2	12	N
1003	3	45	N
1004	4	34	Y
1005	5	23	Y
1006	6	48	Y

Eg: We have enabled relationship and visual interaction as well but after adding this Measure in visual , interaction is not happening. 

In above example count Flag (Y) is 3 so on click on the same it should interact with others to show only rows with Flag = Y in table . Could you please let us know Is there any way to achieve this?

Thanks in Advance!