Based on the slicer selection lookup the value

[Anshenterprices]

Hi TEam,

Source data

Table1		Table2
category	value		category	index id
A	231		A	1
B	323		B	1
c	234		c	1
D	535		D	1
E	543		E	0
slicer
Table1
category

once i select category from slicer then only it should print index id and if it is zero then false

[Samarth_18 · Accepted solution]

You can create a measure with below code

Measure 4 =

VAR selected_category =
SELECTEDVALUE ( Table1[CATEGORY] )
VAR result =
CALCULATE ( MAX ( Table2[index] ), Table2[CATEGORY] = selected_category )
RETURN
IF ( result = 0, FALSE (), result )

when index is 0

when index is 1