Passing single parameter to multiple fields and filtering data

Hi im try to compar 3 fields with single input value. up on selection on single value that need to be passed to 3 fields as below ex: InputVal=10 field1<=10 field2>=10 field3<=10 result should ...

Need Help

affan

7 years ago

Anonymous

You can use the below measure

Measure = var _f1=FIRSTNONBLANK(tbl1[Field1],1)
var _f2=FIRSTNONBLANK(tbl1[Field2],1)
var _f3=FIRSTNONBLANK(tbl1[Field3],1)

var _checkf1=IF(SELECTEDVALUE(tbl2[inputField])<=_f1,1,0)
var _checkf2 = IF(SELECTEDVALUE(tbl2[inputField])<=_f2,1,0)
var _checkf3= IF(SELECTEDVALUE(tbl2[inputField])>=_f3,1,0)
return
_checkf1+_checkf2+_checkf3

Then use this measure in the visual filter and filter the values 3